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

i'M sorry but i dont know where to site vsp to upload large..

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

yea i use cpanel i have an host but where it that thing you talk about

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