Restoring the database from telnet??

[extreme_old]

I have made a dump.sql file of this forum by telnet, by typing this:

mysqldump --opt --user=myusername --password=mypassword mydatabse > /path/to/my/dump/file/dump.sql

It goes fine, but then I try to restore it into a new database named bkjtester, like this:

mysql --user=myusername --password=mypassword mynewdatabase < /path/to/my/dump/file/dump.sql

The this error comes:

ERROR 2006 at line 48: MySQL server has gone away

I'am doing this by telnet, since the dump.sql file is about 27 mb.

How do I restore this into a new database, please help me out here??

[Steve Machol]

For some reason the MySQL server stopped or was being restarted. Have you tried again?

[extreme_old]

Yes, I have tried 4 times now, still the same error??

[Logician]

<a href="http://www.mysql.com/doc/G/o/Gone_away.html" target="_blank">http://www.mysql.com/doc/G/o/Gone_away.html</a>

[Steve Machol]

Originally posted by extreme
Yes, I have tried 4 times now, still the same error?? Ask your host to restart the MySQL server.