MySQL server has gone away (MySQL Server)

Author: Zeeshan Arshad     993     04/03/2012

Estimated reading time: 0 minutes, 24 seconds

Problem: When trying to import OR restore database, the error returns "Mysql server has gone away".

 

Step: Edit [my.cnf -OR- my.ini whichever your web server is using] file that resides inside mysqlbin folder and then try either one OR both of the following solutions.

 

Solution 1: Set max_allowed_packet = 64M

 

Reason 1: Server dropped a large or incorrect packet.

 

Solution 2: Set wait_timeout = 600

 

Reason 2: Server timed out and connection was closed.


Was this topic helpful?

Yes
No
Subscribe YouTube Channel

Zeeshan Arshad is a self-taught and multi-dimensional person with extraordinary track record of success with international clients and students.

Feel free to contact him for your project, training purpose or guidance.