#2006-mysql server 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

MySQL config file mysql ini (partial)

# Example MySQL config file for medium systems.##-a system with little memory (32m-64m) where MySQL plays# a  n important part, or systems up to 128M where MySQL was used together with# other programs (such as a Web server) # # you can Copy this file to#/etc/my.cnf to set global options,# mysql-data-dir/my.cnf to set server-specific options (in this# ins Tallation this directory was C:\mysql\data) or# ~/.my.cnf to set user-specific options.## in this file, you can use all Lon G Options, a program supports.# If you want to know which options a program supports, run the program# with the "--hel P "option.# The following options would be passed to all MySQL clients[client] #password = your_passwordport= 3306socket=/tm p/mysql.sock# here follows entries for some specific programs# the mysql server[wampmysqld] #mysql端口port = 3306socket=/tmp/ mysql.sock# index buffer, determine your index query can access speed key_buffer_size = 16m# Communication Buffer maximum length, determine your SQL statement string maximum length Max_allowed_packet = 1m# sort buffer, Determine the speed of your sort_buffer_size = 512k# PassLetter buffer size, the default value for the query is the communication buffer size, if not enough will automatically increase until max_allowed_packenet_buffer_length = 8kread_buffer_size = 256kread_rnd_buffer_ Size = 512kmyisam_sort_buffer_size = 8M

#2006-mysql server has gone away