'MySQL Error Nr.2013'

[Rorey]

hi, I wana use Mysql Administrator to restore a sql dump created on an offline linux server on to a Web Hosting company Mysql server. but 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'
Using Mysql Administrator, it would not work as well unless I used the Latin1 character set. The dump file is relatively small about 4mb and 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'.
Plz help me out of this! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

Try using the mysql command line utility to load the file:

mysql -h localhost -u root -p dbname < backup.sql
Enter password: ********

this might solve your query! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --