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

How to update Direct Admin skin to Evolution Theme?

Here are very simple steps to update the DIRECT ADMIN skin to the Evolution Theme - 1. cd...

How to forward the website to another URL?

Forwarding the website to another URL - 1. Using index.php file - 1. Create the page as...

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 upgrade mysql with custombuild 2.0?

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

Powered by WHMCompleteSolution