нужна помощь Прошу помочь с базой сервера

[4dminkO 64]

Уважаемые жильцы MAXI, возникла проблема при заливке базы. Выбивает 300 ошибок, уже много чего перепробовал, ставил старый Navicat, но это не помогло. Гуглил, ответа не нашел .

 

Если у кого то нормально залило, сделайте пожалуйста бекап в формате " .PSC "

Буду очень благодарен, с меня "+"

 

Ссылка (НЕ СПАМ / НЕ РЕКЛАМА) :: Щёлк

Прошу модераторов не удалять тему.

Изменено 9 декабря, 2014 пользователем NewBalance

[styler 104]

напиши ошибки

[iChel 15]

там в синтаксе или в кодировке базы,проверь

[4dminkO 64]

напиши ошибки

[Err] 2006 - MySQL server has gone away

[Err] INSERT INTO `enchant_skill_trees` VALUES ('1238','111','Freezing Skin','3','+11 Time','523000','5230000','110','2','10','30','30','30'), ('1238','112','Freezing Skin','3','+12 Time','538000','5380000','111','2','6','20','20','20'), ('1238','113','Freezing Skin','3','+13 Time','659000','6590000','112','2','2','14','14','14'), ('1238','114','Freezing Skin','3','+14 Time','680000','6800000','113','1','2','10','10','10'), ('1238','115','Freezing Skin','3','+15 Time','699000','6990000','114','1','2','6','6','6'), ('1238','116','Freezing Skin','3','+16 Time','857000','8570000','115','1','1','2','2','2'), ('1238','117','Freezing Skin','3','+17 Time','884000','8840000','116','1','1','2','2','2'), ('1238','118','Freezing Skin','3','+18 Time','909000','9090000','117','1','1','2','2','2'), ('1238','119','Freezing Skin','3','+19 Time','1114000','11140000','118','1','1','1','1','1'), ('1238','120','Freezing Skin','3','+20 Time','1149000','11490000','119','1','1','1','1','1'), ('1238','121','Freezing Skin','3','+21 Time','1182000','11820000','120','1','1','1','1','1'), ('1238','122','Freezing Skin','3','+22 Time','1448000','14480000','121','1','1','1','1','1'), ('1238','123','Freezing Skin','3','+23 Time','1494000','14940000','122','1','1','1','1','1'), ('1238','124','Freezing Skin','3','+24 Time','1537000','15370000','123','0','1','1','1','1'), ('1238','125','Freezing Skin','3','+25 Time','1882000','18820000','124','0','1','1','1','1'), ('1238','126','Freezing Skin','3','+26 Time','1942000','19420000','125','0','1','1','1','1'), ('1238','127','Freezing Skin','3','+27 Time','1998000','19980000','126','0','0','1','1','1'), ('1238','128','Freezing Skin','3','+28 Time','2447000','24470000','127','0','0','1','1','1'), ('1238','129','Freezing Skin','3','+29 Time','2525000','25250000','128','0','0','1','1','1'), ('1238','130','Freezing Skin','3','+30 Time','2597000','25970000','129','0','0','0','0','0'), ('1238','141','Freezing Skin','3','+1 Cost','306000','3060000','3','82','92','97','97','97'), ('1238','142','Freezing Skin','3','+2 Cost','315000','3150000','141','80','90','95','95','95'), ('1238','143','Freezing Skin','3','+3 Cost','325000','3250000','142','78','88','93','93','93'), ('1238','144','Freezing Skin','3','+4 Cost','346000','3460000','143','40','82','92','92','92'), ('1238','145','Freezing Skin','3','+5 Cost','357000','3570000','144','30','80','90','90','90'), ('1238','146','Freezing Skin','3','+6 Cost','368000','3680000','145','20','78','88','88','88'), ('1238','147','Freezing Skin','3','+7 Cost','390000','3900000','146','14','40','82','82','82'), ('1238','148','Freezing Skin','3','+8 Cost','402000','4020000','147','10','30','80','80','80'), ('1238','149','Freezing Skin','3','+9 Cost','414000','4140000','148','6','20','78','78','78'), ('1238','150','Freezing Skin','3','+10 Cost','507000','5070000','149','6','14','40','40','40'), ('1238','151','Freezing Skin','3','+11 Cost','523000','5230000','150','2','10','30','30','30'), ('1238','152','Freezing Skin','3','+12 Cost','538000','5380000','151','2','6','20','20','20'), ('1238','153','Freezing Skin','3','+13 Cost','659000','6590000','152','2','2','14','14','14'), ('1238','154','Freezing Skin','3','+14 Cost','680000','6800000','153','1','2','10','10','10'), ('1238','155','Freezing Skin','3','+15 Cost','699000','6990000','154','1','2','6','6','6'), ('1238','156','Freezing Skin','3','+16 Cost','857000','8570000','155','1','1','2','2','2'), ('1238','157','Freezing Skin','3','+17 Cost','884000','8840000','156','1','1','2','2','2'), ('1238','158','Freezing Skin','3','+18 Cost','909000','9090000','157','1','1','2','2','2'), ('1238','159','Freezing Skin','3','+19 Cost','1114000','11140000','158','1','1','1','1','1'), ('1238','160','Freezing Skin','3','+20 Cost','1149000','11490000','159','1','1','1','1','1'), ('1238','161','Freezing Skin','3','+21 Cost','1182000','11820000','160','1','1','1','1','1'), ('1238','162','Freezing Skin','3','+22 Cost','1448000','14480000','161','1','1','1','1','1'), ('1238','163','Freezing Skin','3','+23 Cost','1494000','14940000','162','1','1','1','1','1

[Err] 2006 - MySQL server has gone away

[Err] INSERT INTO `merchant_buylists` VALUES ('7004','29000','335568','24','1','-1','1','1401683493326'), ('7005','29000','335568','25','1','-1','1','1401683493326'), ('7006','29000','335568','26','1','-1','1','1401683493326'), ('7007','29000','335568','27','1','-1','1','1401683493326'), ('7008','29000','335568','28','1','-1','1','1401683493326'), ('7009','29000','335568','29','1','-1','1','1401683493326'), ('7010','29000','335568','30','1','-1','1','1401683493326'), ('7011','29000','335568','31','1','-1','1','1401683493326'), ('7012','29000','335568','32','1','-1','1','1401683493326'), ('7013','29000','335568','33','1','-1','1','1401683493326'), ('6902','12900','135570','1','-1','-1','0','0'), ('1829','500','135570','2','5','-1','1','1401683493326'), ('5169','300','135570','3','5','-1','1','1401683493326'), ('6902','12900','235570','1','-1','-1','0','0'), ('1829','500','235570','2','5','-1','1','1401683493326'), ('5858','100000','235570','3','3','-1','1','1401683493326'), ('5169','300','235570','4','10','-1','1','1401683493326'), ('7129','35000','235570','5','1','-1','1','1401683493326'), ('7130','35000','235570','6','1','-1','1','1401683493326'), ('6902','12900','335570','1','-1','-1','0','0'), ('1829','500','335570','2','5','-1','1','1401683493326'), ('5858','100000','335570','3','3','0','1','1401683493326'), ('5169','300','335570','4','10','-1','1','1401683493326'), ('7129','35000','335570','5','1','-1','1','1401683493326'), ('7130','35000','335570','6','1','-1','1','1401683493326'), ('7584','500000','335570','7','1','-1','2','1401683485637'), ('6928','180','335570','8','1','-1','1','1401683493326'), ('6935','600','335570','9','1','-1','1','1401683493326'), ('6936','1200','335570','10','1','-1','1','1401683493326'), ('6938','1200','335570','11','1','-1','1','1401683493326'), ('6921','250','335570','12','1','-1','1','1401683493326'), ('6923','100000','335570','13','1','-1','1','1401683493326'), ('7691','100000','335570','14','1','-1','1','1401683493326'), ('6947','4000','335570','15','1','-1','1','1401683493326'), ('6948','4000','335570','16','1','-1','1','1401683493326'), ('6949','4000','335570','17','1','-1','1','1401683493326'), ('6950','4000','335570','18','1','-1','1','1401683493326'), ('6951','4000','335570','19','1','-1','1','1401683493326'), ('6952','4000','335570','20','1','-1','1','1401683493326'), ('6953','4000','335570','21','1','-1','1','1401683493326'), ('7002','29000','335570','22','1','-1','1','1401683493326'), ('7003','29000','335570','23','1','-1','1','1401683493326'), ('7004','29000','335570','24','1','-1','1','1401683493326'), ('7005','29000','335570','25','1','-1','1','1401683493326'), ('7006','29000','335570','26','1','-1','1','1401683493326'), ('7007','29000','335570','27','1','-1','1','1401683493326'), ('7008','29000','335570','28','1','-1','1','1401683493326'), ('7009','29000','335570','29','1','-1','1','1401683493326'), ('7010','29000','335570','30','1','-1','1','1401683493326'), ('7011','29000','335570','31','1','-1','1','1401683493326'), ('7012','29000','335570','32','1','-1','1','1401683493326'), ('7013','29000','335570','33','1','-1','1','1401683493326'), ('6902','12900','135572','1','-1','-1','0','0'), ('1829','500','135572','2','5','-1','1','1401683493326'), ('5169','300','135572','3','5','-1','1','1401683493326'), ('6902','12900','235572','1','-1','-1','0','0'), ('1829','500','235572','2','5','-1','1','1401683493326'), ('5858','100000','235572','3','3','-1','1','1401683493326'), ('5169','300','235572','4','10','-1','1','1401683493326'), ('7129','35000','235572','5','1','-1','1','1401683493326'), ('7130','35000','235572','6','1','-1','1','1401683493326'), ('6902','12900','335572','1','-1','-1','0','0'), ('1829','500','335572','2','5','0','1','1401683493326'), ('5858','100000','335572','3','3','0','1','1401683493326'), ('5169','300','335572','4','10','-1','1','1401683493326'), ('7129','35000','335572','5','1','0','1','1401683493326'), ('7130','35000','335572','6','1','0','1','1401683493326'), ('7584','500000','335572','7','1','0','2','1401683485637'), ('6928','180','335572','8','1','-1',

[Err] 2006 - MySQL server has gone away

[Err] INSERT INTO `npc` VALUES ('21129','21129','Kerope Werewolf Chief','0','','0','5','11.00','29.70','23','male','L2Monster','40','648','257','5.53','1.53','40','43','30','21','20','10','895','43','82','82','31','87','278','400','333','0','0','0','55','154','werewolf_clan','300','0','0','LAST_HIT','100','0','30','fighter','true'), ('21130','21130','Northern Goblin Leader','0','','0','5','4.00','15.00','24','male','L2Monster','40','687','272','5.53','1.53','40','43','30','21','20','10','954','47','81','111','34','90','278','400','333','66','102','0','33','137','goblin_clan','300','0','0','LAST_HIT','100','0','30','fighter','true'), ('21131','21131','Enchanted Spine Golem','0','','0','5','20.00','40.30','25','male','L2Monster','40','728','287','5.53','1.53','40','43','30','21','20','10','992','50','97','105','37','94','278','0','333','0','0','0','25','31','NULL','0','0','0','LAST_HIT','100','0','30','fighter','true'), ('21132','21132','Underground Kobold','0','','0','5','10.00','15.00','24','male','L2Monster','40','687','272','5.53','1.53','40','43','30','21','20','10','779','38','81','94','34','90','278','0','333','0','0','0','51','121','kobold_clan','300','0','0','LAST_HIT','100','0','30','fighter','false'), ('21133','21133','Dead Pit Skeleton Archer','0','','0','5','11.00','27.00','25','male','L2Monster','500','728','287','5.53','1.53','40','43','30','21','20','10','851','43','197','98','37','94','249','0','333','274','0','0','44','143','undead_clan','300','1','0','LAST_HIT','100','0','30','archer','false'), ('21134','21134','Dead Pit Spartoi','0','','0','5','11.00','27.00','26','male','L2Monster','40','770','303','5.53','1.53','40','43','30','21','20','10','898','45','96','102','41','98','278','400','333','219','0','0','66','159','undead_clan','300','1','0','LAST_HIT','100','0','30','fighter','false'), ('21135','21135','Underground Kobold Warrior','0','','0','5','10.00','15.00','27','male','L2Monster','40','813','318','5.53','1.53','40','43','30','21','20','10','1103','56','114','114','45','102','278','0','333','0','0','0','51','126','kobold_clan','300','0','0','LAST_HIT','100','0','30','fighter','false'), ('21136','21136','Dead Pit Horror','0','','0','5','20.00','35.00','28','male','L2Monster','40','859','334','5.53','1.53','40','43','30','21','20','10','981','52','113','110','49','106','278','0','333','0','0','0','110','110','undead_clan','300','1','0','LAST_HIT','100','0','30','fighter','false'), ('21137','21137','Iron Ore Golem','0','','0','5','18.00','34.00','29','male','L2Monster','40','906','349','5.53','1.53','40','43','30','21','20','10','1057','57','111','149','53','110','278','400','333','0','0','0','22','23','NULL','0','0','0','LAST_HIT','100','0','30','fighter','false'), ('21138','21138','Greedy Geist','0','','0','5','30.00','40.00','30','male','L2Monster','40','954','365','5.53','1.53','40','43','30','21','20','10','1134','62','132','119','58','114','278','0','333','0','0','0','16','165','undead_clan','300','1','0','LAST_HIT','100','0','30','fighter','false'), ('21139','21139','Catacomb Barbed Bat','0','','0','5','10.00','33.50','23','male','L2Monster','40','648','257','22.12','1.53','40','43','30','21','20','10','655','31','75','91','31','87','278','500','333','0','0','0','66','143','c_dungeon_clan','300','0','0','LAST_HIT','0','0','0','fighter','false'), ('21140','21140','Catacomb Wisp','0','','0','5','13.00','22.00','26','male','L2Monster','40','770','303','22.12','1.53','40','43','30','21','20','10','788','39','96','102','41','98','278','500','333','0','0','0','88','132','c_dungeon_clan','300','0','0','LAST_HIT','0','0','0','fighter','false'), ('21141','21141','Catacomb Serpent','0','','0','5','17.00','46.00','28','male','L2Monster','40','859','334','22.12','1.53','40','43','30','21','20','10','926','48','113','110','49','106','278','500','333','73','0','0','77','143','c_dungeon_clan','300','0','0','LAST_HIT','0','0','0','fighter','false'), ('21142','21142','Grave Keeper Spartoi','0','','0','5','11.00','27.00','29','male','L2Monster','40','906','349','22.12','1.53','40','43','30','21','20','10','927

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

 

[styler 104]

http://www.it-rem.ru/kak-ispravit-mysql-server-has-gone-away-error-2006.html

[4dminkO 64]

Может вот так удобней будетERROR DB.txt

[4dminkO 64]

http://www.it-rem.ru...error-2006.html

 

Это только с этой базой такие ошибки, и они не у меня одного. Попробуй себе в залить в базу и сделать бекап в формате .psc

Там делов на 1 минуту и скинь мне. В 1 нормально, а в других такая же фишка :-(

 

Или мб через тв(tv) поможете ?

Изменено 9 декабря, 2014 пользователем NewBalance

[4dminkO 64]

Тема, up

[KaRmiN 1265]

ПРОБУЙ

Токо перед етим удали все таблицы из базы!

Изменено 9 декабря, 2014 пользователем KaRmiN

[4dminkO 64]

ПРОБУЙ

Токо перед етим удали все таблицы из базы!

Спасибо, все роботает)))) держи +1