MySQL error 2006: mysql server has gone away

mysql mysql-error-2006
floatleft picture floatleft · Oct 30, 2011 · Viewed 459k times · Source

I'm running a server at my office to process some files and report the results to a remote MySQL server.

The files processing takes some time and the process dies halfway through with the following error: 

2006, MySQL server has gone away

I've heard about the MySQL setting, wait_timeout, but do I need to change that on the server at my office or the remote MySQL server?

Answer

George picture George · Feb 28, 2012

I've encountered this a number of times and I've normally found the answer to be a very low default setting of max_allowed_packet.

Raising it in /etc/my.cnf (under [mysqld]) to 8 or 16M usually fixes it. (The default in MySql 5.7 is 4194304, which is 4MB.)

[mysqld]
max_allowed_packet=16M

Note: Just create the line if it does not exist

Note: This can be set on your server as it's running.

Use set global max_allowed_packet=104857600. This sets it to 100MB.

Related questions

Getting MYSQL Error: "Error Code: 2006 - MySQL server has gone away"

I am getting following error, when I try to import MYSQL database: Error Code: 2013 - Lost connection to MySQL server during queryQuery: Error Code: 2006 - MySQL server has gone away Can someone let me know what is wrong?

Read More
#2006 MySQL Server has gone away error in Wamp

Im using Wampserver version 2.0 . When i try to import a sql file, either through MySQL Query Browser or PHPMyAdmin,i get the following error. Error 2006: MySQL Server has gone away. The size of the file is 54,528 KB. In C:\wamp\…

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More