Knowledgebase

when I try to load sql dump, I receive the following: error 2006: mysql server has gone away?  Print this Article

To address this issue, perform the following:

 

  1. Open the /etc/my.cnf file with your preferred text editor.
  2. Enter max_allowed_packet=#* in the [mysqld] section.Save the file.Save the file.
  3. Save the file
  4. Restart MySQL with the # /scripts/restartsrv_mysql command.

* Replace # with number

Was this answer helpful?

Also Read

how do I export a mysql database?
Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category....
how do I import a mysql database?
Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category....
what is phpmyadmin?
phpMyAdmin is a graphical user interface (GUI) used for managing data within a MySQL database....
why the mysql version shows a different version in phpinfo than installed on the server?
The API version you see in phpinfo is the built-in MySQL API that is included in PHP. If the...
how do I delete a mysql database?
Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...