MyServer Has Gone Away Error Message

Issue: When large amounts of data are being stored with MySQL, the following error message can happen.

Resolution: Modify the MySQL configuration file (/etc/my.cnf) and increase the max_allowed_packet size.

vi /etc/my.cnf

Edit max_allowed_packet to be larger than the size of your data transfer in bytes (e.g. 16000000 is roughly 16 MB). max_allowed_packet=16000000

Save the file and restart MySQL. If the error is still present, increase the max_allowed_packet size again.

Sample File:

[mysqld]

max_allowed_packet=16777216