Error Nr.2013-Lost connection....

[Kamch]

hello there,
I am looking to use Mysql Administrator to restore a sql dump created on an offline linux server on to a Web Hosting company Mysql server. I had trouble getting a dump file syntax that would not fall over but the following command seems to produce a backup file that should work - 'mysqldump --opt ourdbasename -uroot > backup.sql'
With Mysql Administrator, I found that it would not work at all unless I used the Latin1 character set. The dump file is about 4mb. It starts to load but after getting through 1200000 bytes, falls over with the following message 'MySQL Error Nr.2013-Lost connection to MySQL server during query'. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[evy]

My suggestion will be to try and use the mysql command line utility to load the file:
mysql -h localhost -u root -p dbname < backup.sql
Enter password: ******** -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --