MySQL restore problem - MySQL server has gone away error

[Web_news]

Hi,

I am restoring one large Joomla database on my Linux VPS. Since it is large database, I migrated sql dump file (.sql) to my Linux VPS and trying to restore it via SSH. During restore it is giving me following error after some time:

ERROR 2006 (HY000) at line 17452: MySQL server has gone away

The sql backup was generated without any error. Am I missing something? Please help!

Thanks in advance!

[Kailash]

It looks like you are hitting max packet size during restore. You need to edit your MySQL configuration file (my.cnf) to increase packet size. Add the following line in [mysqld] section and restart MySQL service:

max_allowed_packet = 32M

After restarting MySQL try again to restore your MySQL database.

- Kailash

[Web_news]

Thanks Kailash!