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

Problem:

Getting error 2006 during database backup import. The problem is in short timeout and small packet size. It’s necessary to update my.cnf and restart MySql service.

Solution:

[mysqld]
max_allowed_packet = 64M
wait_timeout = 6000

[mysqldump]
max_allowed_packet = 64M

External links

• http://stackoverflow.com/questions/13323833/error-2006-hy000-at-line-1-mysql-server-has-gone-away