MySQL Forums :: Newbie :: MySQL server has gone away


Advanced Search

MySQL server has gone away
Posted by: Greg DeBacker ()
Date: June 15, 2010 10:24AM

This is day 3 of trying to restore a table from mysqldump back to a MySQL db. This db has over 900 tables, but I'm just trying to get one table restored now. I used the *.sql file to recreate the table structure. I then tried to load the corresponding *.txt file and then error I get is "MySQL server has gone away".

The txt file is about 9 megs, not huge, but I decided just try and run a few lines from the file to see what that would do. This time it bombed on line one and told me there was an error in the syntax of the sql statement. I deleted line and got the same error on the next line. I tried other files and got similar errors.

The txt files are tab delimted. I imported it in to an Access database and it imported fine. I got 47 columns in Access and the MySQL table structure that was built from the sql file has 47 columns.

I am at a loss as to how to continue. I read the http://dev.mysql.com/doc/refman/5.0/en/gone-away.html section in the reference manual and it shed no light on how to resolve this. I restarted the MySQL service and tried again with the same results.

Any ideas?

Greg

Options: ReplyQuote


Subject Written By Posted
MySQL server has gone away Greg DeBacker 06/15/2010 10:24AM
Re: MySQL server has gone away Greg DeBacker 06/15/2010 10:41AM
Re: MySQL server has gone away Shawn Taylor 06/15/2010 11:53AM
Re: MySQL server has gone away Greg DeBacker 06/15/2010 12:17PM
Re: MySQL server has gone away Shawn Taylor 06/15/2010 02:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.