• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

MySQL restore problem - MySQL server has gone away error

Started by Web_news, June 15, 2013, 11:00:53 AM

Divi WordPress Theme


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


Divi WordPress Theme