restoring a sql dump?

[Qlance]

Hello people,
I am using Mysql Administrator to restore a sql dump created on an offline linux server on to a Web Hosting company Mysql server. I am finding difficulty 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'.
Trying Mysql Administrator, I found that it would not work at all unless I used the Latin1 character set. The dump file is relatively small about 4mb. What happens every time is that it starts to load but after getting through about 1200000 bytes, falls over with the following message 'MySQL Error Nr.2013-Lost connection to MySQL server during query'. I tried to recreate the dump but it always falls over. Any advice you can offer?
Thanks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Terrell]

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 --