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!

Was this answer helpful?

 Print this Article

Also Read

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

How to update Apache to latest version?

Steps to update Apache to latest version -1. Please check the current version of Apache using...

How to reset and retrieve directadmin admin password using shell?

Steps to reset the direct admin password -1. Login to SSH with root user -#passwd admin 2. This...

Powered by WHMCompleteSolution