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

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?

 Print this Article

Also Read

I want to use applications directly from my computer to connect to a mysql database which port can I use to connect to database?

You should use port 3306 to connect to MySQL server

what is phpmyadmin?

phpMyAdmin is a graphical user interface (GUI) used for managing data within a MySQL database....

can users be assigned privileges to a certain number of mysql databases and a different number of postgresql databases?

No. However, packages allow you to set the maximum number of databases an user can create...

how do I delete a mysql database?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...

why do I see: error at line 2: unknown command '\_'. when I list mysql databases?

You have MySQL version 4.0.12 which has a bug that causes this error. Upgrade to a later version...