Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ERROR: MySQL server has gone away

Status
Not open for further replies.

DavidRock

Programmer
Jul 24, 2002
61
US
Hello,

I'm trying to restore a MySQL backup to a newly configured Windows 2K Server. The backup was created with mysqldump on a Windows 2K Server, running MySQL 4.0.20. I'm trying to restore the backup to the new box, which is running MySQL 4.1.7. But I keep getting "ERROR 2006 (HY000) at line 1253: MySQL server has gone away". Line 1253 is a fairly large INPUT statement. The backup will restore to other servers without error. Any idea what could be causing this?

Thank you in advance for any suggestions.

David
 
How large is large? Sounds like its timing out on the insert...

Bastien

Cat, the other other white meat
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top