Database Recovery Issue!

[Submit]

Another issue! XD

So i backed up my DB into a pretty large SQL file. The problem is when i go to extract it to either a fresh and/or exsisting DB, i get a run times error.






Here is the Error Log:

<Bunch of Data Here, To much to fit>
Error occured at:2009-03-01 15:13:00
Line no.:201
Error Code: 2006 - MySQL server has gone away


Idk why this is happening!

[Submit]

bump, rly need help!

[Vindicated]

Go to your MySQL > MySQL Server 5.1 (or whatever version you have) folder in your Program Files.

In the my-huge, my-large, my-medium, and my-small folders change max_allowed_packet to 16M.

[Reflection]

Never had that error personally but I scooped old threads a bit.. It seems that the error is caused either because you have old database still there, probably not but most likely it's because you lose connection to the server while executing, try to reinstall mysql and it might work out.

Good luck.

[Submit]

Go to your MySQL > MySQL Server 5.1 (or whatever version you have) folder in your Program Files.

In the my-huge, my-large, my-medium, and my-small folders change max_allowed_packet to 16M.

Didn't work =/ You want me to send u a link to the SQL? Take a look at it.

[Submit]

I use SQLyog, could this be an issue?

[Vindicated]

I used Navicat Lite and it imported great.

[Submit]

Grabing Navicat now, thanks for the time, +repx2

[Submit]

I used Navicat Lite and it imported great.

Hrm... just DL's Navicat 8, uploaded the SQL and am stuck on Query 32 with error:

insert  into `creature_names`(`entry`,`name`,`subname`,`info_str`,`Flags1`,`type`,`family`,`rank`,`unk4`,`spelldataid`,`male_displayid`,`female_displayid`,`male_displayid2`,`female_displayid2`,`unknown_float1`,`unknown_float2`,`civilian`,`leader`) values (0,'Spawn Point (Only GM can see it)','','',0,1,0,3,0,0,262,0,0,0,1,1,NULL,0),(1,'Waypoint (Only GM can see it)','Visual','',5242886,8,8,0,0,0,10045,0,0,0,1,1,NULL,0),(3,'Flesh Eater','','',0,6,0,0,0,0,987,0,0,0,1.02,1,NULL,0),(6,'Kobold Vermin','','',0,7,0,0,0,0,10913,0,0,0,1,1,NULL,0),(19,'Benny Questgiver','NPC','',0,7,0,0,0,0,6074,0,0,0,1,1,NULL,0),(29,'Kanrethad','Master of Death','',0,7,0,0,0,0,25275,0,0,0,1250,1,NULL,0),(30,'Forest Spider','','',1,1,3,0,0,5880,382,0,0,0,1,1,NULL,0),(31,'Furbolg','','',0,0,0,0,0,0,145,0,0,0,1,1,NULL,0),(36,'Harvest Golem','','',32768,9,0,0,0,0,367,0,0,0,1,1,NULL,0),(38,'Defias Thug','','',0,7,0,0,0,0,5035,5036,0,0,1,1,NULL,0),(40,'Kobold Miner','','',0,7,0,0,0,0,373,0,0,0,1,1,NULL,0),(43,'Mine Spider','','',1,1,3,0,0,10495,368,0,0,0,1,1,NULL,0),(46,'Murloc Forager','','',0,7,0,0,0,0,441,0,0,0,1,1,NULL,0),(48,'Skeletal Warrior','','',0,6,0,0,0,0,200,0,0,0,1.02,1,NULL,0),(49,'Lesser Succubus','','',0,3,0,0,0,0,159,0,0,0,1,1,NULL,0),(54,'Corina Steele','Weaponsmith','',0,7,0,0,0,0,1287,0,0,0,1,1,NULL,0),(55,'Mean Ed the Blacksmith','','',0,7,0,0,0,0,17,0,0,0,1,1,NULL,0),(60,'Ruklar the Trapper','','',0,7,0,0,0,0,2153,0,0,0,1,1,NULL,0),(61,'Thuros Lightfingers','','',0,7,0,4,0,0,3341,0,0,0,1,1,NULL,0),(62,'Gug Fatcandle','','',0,7,0,0,0,0,26,0,0,0,1,1,NULL,0),(65,'Peasant Woman','','',0,7,0,0,0,0,13,0,0,0,1,1,NULL,0),(66,'Tharynn Bouden','Trade Supplies','',0,7,0,0,0,0,1298,0,0,0,1,1,NULL,0),(67,'[UNUSED] Marlon Darnik','Grocer','',0,7,0,0,0,0,23,0,0,0,1,1,NULL,0),(68,'Stormwind City Guard','','Directions',0,7,0,0,0,0,3167,5446,0,0,1.5,1,NULL,0),(69,'Timber Wolf','','',1,1,1,0,0,13060,604,0,0,0,1,1,NULL,0),(70,'[UNUSED] Lower Class Citizen','','',0,7,0,0,0,0,13,0,0,0,1,1,NULL,0),(71,'Rankist','','',0,0,0,0,0,0,137,0,0,0,1,1,NULL,0),(72,'[UNUSED] Antaris the Trader','','',0,7,0,0,0,0,19,0,0,0,1.2,1,NULL,0),(73,'Veraina the Apothecary','Questgiver','',0,7,0,0,0,0,15,0,0,0,1.15,1,NULL,0),(74,'Kurran Steele','Cloth & Leather Armor Merchant','',0,7,0,0,0,0,1289,0,0,0,1,1,NULL,0),(75,'[UNUSED] Vashaum Nightwither','','',0,7,0,0,0,0,166,0,0,0,1,1,NULL,0),(78,'Janos Hammerknuckle','Weaponsmith','',0,7,0,0,0,0,3275,0,0,0,1,1,NULL,0),(79,'Narg the Taskmaster','','',0,7,0,4,0,0,774,0,0,0,1.3,1,NULL,0),(80,'Kobold Laborer','','',0,7,0,0,0,0,365,0,0,0,1,1,NULL,0),(81,'[UNUSED] Luglar the Clogger','','',0,7,0,0,0,0,371,0,0,0,1,1,NULL,0),(82,'Crazy Leonetti','','',0,7,0,0,0,0,16,0,0,0,1,1,NULL,0),(87,'Forest Troll Berserker','','',0,7,0,0,0,0,167,0,0,0,1,1,NULL,0),(89,'Infernal','','',0,3,19,0,0,0,169,0,0,0,1.9,1,NULL,0),(90,'Sea Giant','','',0,5,0,0,0,0,791,0,0,0,1,1,NULL,0),(92,'Rock Elemental','','',0,4,0,0,0,0,171,0,0,0,1.15,1,NULL,0),(93,'Centaur','','',0,0,0,0,0,0,172,0,0,0,1,1,NULL,0),(94,'Defias Cutpurse','','',0,7,0,0,0,0,2361,2362,0,0,1,1,NULL,0),(95,'Defias Smuggler','','',0,7,0,0,0,0,4418,4419,0,0,1,1,NULL,0),(97,'Riverpaw Runt','','',0,7,0,0,0,0,10791,0,0,0,1,1,NULL,0),(98,'Riverpaw Taskmaster','','',0,7,0,0,0,0,376,0,0,0,1,1,NULL,0),(99,'Morgaine the Sly','','',0,7,0,4,0,0,3320,0,0,0,1,1,NULL,0),(100,'Gruff Swiftbite','','',0,7,0,4,0,0,175,0,0,0,1,1,NULL,0),(102,'Bronze Dragonspawn','','',0,0,0,0,0,0,177,0,0,0,1,1,NULL,0),(103,'Garrick Padfoot','','',0,7,0,0,0,0,2073,0,0,0,1,1,NULL,0),(105,'Tall Strider','','',0,0,12,0,0,0,178,0,0,0,1,1,NULL,0),(106,'Kodo Beast','','',0,1,0,0,0,0,179,0,0,0,1,1,NULL,0),(107,'Raptor','','',1,1,11,0,0,0,180,0,0,0,1,1,NULL,0),(108,'Green Dragonspawn','','',0,0,0,0,0,0,181,0,0,0,1,1,NULL,0),(109,'White Dragonspawn','','',0,0,0,0,0,0,182,0,0,0,1,1,NULL,0),(111,'Priest','','',0,7,0,0,0,0,20,0,0,0,1,1,NULL,0),(112,'Priestess','','',0,7,0,0,0,0,14,0,0,0,1,1,NULL,0),(113,'Stonetusk Boar','','',1,1,5,0,0,9081,503,0,0,0,1,1,NULL,0),(114,'Harvest Watcher','','',0,9,0

[Reflection]

Yea I use navicat lite too, never had the problem. Hopefully it'll get fixed.

Edit: What's the error? That's just the queues.

[Submit]

Yea I use navicat lite too, never had the problem. Hopefully it'll get fixed.

Edit: What's the error? That's just the queues.

[Err] 2013 - Lost connection to MySQL server during query
[Err] /*Data for the table `creature_names` */

[Submit]

Bump!!!!! Still need Help!

[Submit]

Bump!!!!!!!!!!!!!!!!!!!!!!

[ZestyJ]

Well its probably an error within the file in which you would have to find line 201 and manually fix it.

[Submit]

Well its probably an error within the file in which you would have to find line 201 and manually fix it.

Deleted the line 201 but still get the same issue, ill send u via PM the SQL. Please help :P