Error when restoring mysql dump - Site Down

[VirtueTech]

Hello,

I keep getting this error when I try to restore a mysql dump '.sql' file into a blank database:

ERROR 2013 at line 67: Lost connection to MySQL server during query

I am using this command to try and restore:
./mysql pbcforum13 < /web/backup/paintballforum11_20020225.sql -u*** -p***

Can someone please tell me why? Thanks.

If I force the restore using '-f' it still just errors out eventually. This is very odd.

[steven]

try mysql -uusername -ppassword database_name < backupfile.sql

also looks like the mysql server is going down as a result of the import.

[eva2000]

use this command

mysql -u mysqlusername -p databasename < /path/to/backup.sql

it could be that you need to reoptimise your my.cnf file again

[VirtueTech]

Ok thanks...what settings should I use for my.cnf?

[eva2000]

Originally posted by VirtueTech
Ok thanks...what settings should I use for my.cnf? under [mysqld] section add

set-variable = max_allowed_packet=16M

if it isn't there or increase it from default 1M to 16M