#2006-mysqlserver has gone away

#2006-mysql server has gone away

For Web applications, MySQL is often used, and data backup and restore is often done by Web applications, in general, with the client tool Phpmyadmin,sqlyog, etc., to back up the database without any problems, restore often encountered MySQL prompt #2006 error.

Error: 2006 (CR_SERVER_GONE_ERROR)

Message:mysql server has gone away

The reason may be that the SQL statement is too long, exceeding the maximum length of MySQL communication buffer;

Adjust the MySQL configuration file in Max_allowed_packet

max_allowed_packet=300m wait_timeout=200000 interactive_timeout = 200000

Restart MySQL, Apache

#2006-mysqlserver has gone away