MySQL: restoring database and MySQL Server GONE AWAY....what is the reason ???

MySQL: restoring database and MySQL Server GONE AWAY....what is the reason ???

Posted: 10 years ago in  Unix | Database | MySQL |

This error is occurred when you try to restore big, very big database file. Hope the way I write here help you save a bit of time 8-)

This error is occurred when you try to restore big, very big database file. Hope the way I write here help you save a bit of time 8-)

The solution is quite simple by increase max_allowed_packet.

Go to /etc/mysql and edit my.cnf

Find max_allow_packet and change to 512M (it is fine for me to restore 400MB database file with 521MB)

Good luck

Tags:
• Tips & Tricks