Problem Restoring A Database

[joben1]

When trying to restore a database in ssh I get the following error:

ERROR 1153 (08S01) at line 371: Got a packet bigger than 'max_allowed_packet' bytes

It seems that max_allowed_packet needs increasing. How do I do that?

I am using this command:
mysql -h localhost -u root DATABASE < DATABASE.sql

[jayh38]

I believe the default is 1mb, you would set the value from ssh.

mysql --max_allowed_packet=16M (or whatever value needed to run)

If you need to load the variable all the time then simply add max_allowed_packet into my.cnf as well.

Yep the default is 1mb:
mysql> show variables like 'max&#37;' ;

[joben1]

When I do that I get: "Welcome to the mysql monitor." - and a load of other help info.

[jayh38]

Ahh ok..

Then enter the mysql monitor and use this instead:

mysql>set max_allowed_packet = 1600000;

Verify the change before and after:
mysql>show variables like 'max&#37;';

ooops , thats 1.6M I showed. So edit the size as you need.

[jayh38]

you are very much welcome!