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 update Apache to latest version?

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

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 forward the website to another URL?

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

Powered by WHMCompleteSolution