|
#1
|
|||
|
|||
Problem
heloo i have an sql db of 100 mb and on my upload server max 2 ,1 mb i zipped with winrar but it to larger 18 mb i try with splitter and make me 20 sql spltter arhives.and thw i try to upload give me error ..wich recomand me?
. |
#2
|
|||
|
|||
You can always open it in Notepad or Notepad++, press Ctrl+A, then Ctrl+C and then in your phpmyadmin open database, choose "SQL" on top and then press Ctrl+V to copy everything in. But that amount of text may crash you. But you can always try it!
|
#3
|
||||
|
||||
use bigdump
http://www.ozerov.de/bigdump/
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#4
|
||||
|
||||
hi
and if big dump dont work you need to go vps and set your file upload to what ever you need then. ive had success with bigdump and had issues good luck
__________________
7.5 tsse future tracker source & hosting, vps trackers installs + Themes http://www.foxyhosting.co.uk http://www.downmy.top testing zone offshore vps & cpanel hosting & Shoutcast & VPN STOP cyberbullying any setups tracker installs vps hosting vps setups themes mods hit me up over the last three months ive become a snake breeder,pythons,hogs,boa,corn,rat,king,carpet and what joy it is |
#5
|
|||
|
|||
Can't open import for import
Please, check that your dump file name contains only alphanumerical characters, and rename it accordingly, for example: import. Or, specify $filename in bigdump.php with the full filename. Or, you have to upload the import to the server first. i solv first problem but:( Error at the line 174: (170, 128, 2731); Query: -- -- INSERT INTO `addedrequests` (`id`, `requestid`, `userid`) VALUES (2, 2, 2731), (3, 3, 2731), (19, 19, 2731), (18, 18, 2731), (33, 23, 5682), (21, 19, 5682), (14, 14, 2731), (15, 15, 2731), (20, 19, 5232), (22, 20, 5314), (23, 19, 5314), (24, 20, 2731), (32, 23, 2731), (26, 21, 5314), (27, 21, 2731), (28, 22, 5314), (29, 22, 2731), (30, 21, 5682), (31, 22, 5682), (34, 24, 2731), (35, 24, 5682), (36, 25, 2793), (37, 25, 2731), (38, 25, 5682), (39, 26, 2731), (40, 27, 2731), (41, 28, 2731), (42, 29, 2731), (43, 26, 5682), (44, 29, 5682), (45, 27, 5314), (46, 28, 5314), (47, 30, 5314), (48, 30, 2731), (49, 30, 5682), (50, 31, 5314), (51, 31, 2731), (52, 32, 2793), (53, 32, 2731), (59, 38, 2731), (55, 34, 2731), (60, 39, 2731), (61, 40, 2731), (99, 78, 2731), (63, 42, 2731), (64, 43, 2731), (65, 44, 2731), (66, 45, 2731), (67, 46, 2731), (68, 47, 2731), (69, 48, 2731), (70, 49, 2731), (71, 50, 2731), (72, 51, 2731), (73, 52, 2731), (74, 53, 2731), (75, 54, 2731), (76, 55, 2731), (77, 56, 2731), (78, 57, 2731), (79, 58, 2731), (80, 59, 2731), (81, 60, 2731), (82, 61, 2731), (83, 62, 2731), (84, 63, 2731), (85, 64, 2731), (86, 65, 2731), (88, 67, 2731), (89, 68, 2731), (90, 69, 2731), (91, 70, 2731), (92, 71, 2731), (93, 72, 2731), (94, 73, 2731), (95, 74, 2731), (96, 75, 2731), (97, 76, 2731), (98, 77, 2731), (117, 96, 2731), (118, 97, 2731), (119, 98, 2731), (120, 99, 2731), (121, 100, 2731), (122, 101, 2731), (123, 102, 2731), (124, 103, 2731), (125, 104, 2731), (126, 105, 2731), (127, 106, 2731), (128, 107, 2731), (129, 108, 2731), (130, 109, 2731), (131, 110, 2731), (132, 111, 2731), (133, 112, 2731), (134, 113, 2731), (135, 114, 2731), (136, 115, 2731), (137, 116, 2731), (138, 77, 6742), (139, 30, 6742), (140, 14, 6742), (141, 117, 2731), (142, 118, 2731), (143, 46, 9974), (144, 119, 10268), (145, 119, 2731), (146, 120, 2731), (147, 121, 2731), (148, 122, 2731), (149, 120, 3224), (150, 123, 2731), (151, 124, 3413), (152, 124, 2731), (153, 122, 12671), (154, 125, 4135), (155, 126, 2793), (156, 126, 2731), (157, 53, 12671), (158, 56, 12671), (159, 77, 13120), (160, 127, 9301), (161, 128, 9301), (162, 129, 9301), (163, 130, 9301), (164, 131, 9301), (165, 131, 2899), (166, 130, 2899), (167, 131, 2731), (168, 130, 2731), (169, 129, 2731), (170, 128, 2731); MySQL: Duplicate entry '2' for key 'PRIMARY' |
#6
|
||||
|
||||
hi
read what i say above if it dont work you need to upgrade your host to vps or one with a larger mysql import other than that have a good evening
__________________
7.5 tsse future tracker source & hosting, vps trackers installs + Themes http://www.foxyhosting.co.uk http://www.downmy.top testing zone offshore vps & cpanel hosting & Shoutcast & VPN STOP cyberbullying any setups tracker installs vps hosting vps setups themes mods hit me up over the last three months ive become a snake breeder,pythons,hogs,boa,corn,rat,king,carpet and what joy it is |
#7
|
|||
|
|||
i'M sorry but i dont know where to site vsp to upload large..
|
#8
|
||||
|
||||
hi
right now your using shared hosting? with cpanel example
so you have outgrown your hosting now you need vps hosting so you can upload files sizes like 200mb and so on these run from a few £ upwards i sell vps and others
__________________
7.5 tsse future tracker source & hosting, vps trackers installs + Themes http://www.foxyhosting.co.uk http://www.downmy.top testing zone offshore vps & cpanel hosting & Shoutcast & VPN STOP cyberbullying any setups tracker installs vps hosting vps setups themes mods hit me up over the last three months ive become a snake breeder,pythons,hogs,boa,corn,rat,king,carpet and what joy it is |
#9
|
|||
|
|||
yea i use cpanel i have an host but where it that thing you talk about
|
#10
|
||||
|
||||
hi
host-us my link underneath we host vps nodes which can do this
this dont mean purchasing a cpanel hosting again from me lol especially in the name your trying to purchase in YOU NEED VPS
__________________
7.5 tsse future tracker source & hosting, vps trackers installs + Themes http://www.foxyhosting.co.uk http://www.downmy.top testing zone offshore vps & cpanel hosting & Shoutcast & VPN STOP cyberbullying any setups tracker installs vps hosting vps setups themes mods hit me up over the last three months ive become a snake breeder,pythons,hogs,boa,corn,rat,king,carpet and what joy it is Last edited by x360zone; 17th February 2013 at 23:36. |
Tags |
problem |
|
|