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?
. |
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!
|
use bigdump
http://www.ozerov.de/bigdump/ |
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
|
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' |
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
|
Quote:
|
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 |
Quote:
|
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 :suicide: YOU NEED VPS |
All times are GMT +2. The time now is 02:30. |
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.