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.
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.