MySql Database has gone away

You may come across the error "MySql Database has gone away". I came across this error while restoring the database .

All you need to do under this situation is add max_allowed_packet parameter to /etc/my.cnf file and that will do the trick for you -

[root@xyz]# cat /etc/my.cnf
[mysqld]
max_allowed_packet=300M

That's it!
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to upgrade the php from 5.4 to 5.6?

If you are running php 5.4 on the server and want it to be upgraded to 5.6 . Additionally, your...

How to list all files under directory?

When there is no 'index.php' or 'index.html' file and you'd like to display all the files under...

How to upgrade mysql with custombuild 2.0?

Before doing any updates of MySQL be sure to create full backups of all databases.Steps to...

How to install xmlrpc?

Installing xmlrpc module on Directadmin. Seems simple isn't it ? Might find many articles on the...

How to run CGI script using any directory or /~username/cgi-bin?

If you would like to force Apache to allow CGI script then just follow below simple steps - 1....

Powered by WHMCompleteSolution