MYSQL dump restore error 2006
Posted on 2009-05-19
I am having issue trying to restore a MYSQL dump file to MYSQL Server 5.0 on a Windows 2003 RS 32bit platform.
I run the command
shell>mysql --user=user --password dbname < d:\dump\dbname.sql
It begins to run and then I receive the following error message....
ERROR 2006 <HYP000> at line 1311: MySQL Server has gone away.
I have read that the issue could be due to the max allowed packet being too small for the restore query and that it could be timing out so I added the following to my.ini file.
wait_timeout = 1800
After the changes I restarted MYSQL service and tried the restore again but I get the same error except a different line...
ERROR 2006 <HYP000> at line 1313: MySQL Server has gone away.
Does anyone have any ideas why this is happening? The point of this excersize is to set up replication on a slave server so I am stuck right now. please help. Thanks :)