MySQL error 2006: mysql server has gone away

Question

I am running a server at my office to process some files and report the results to a remote MySQL server.

The files processing takes some time and the process dies halfway through with the below error:

2006, MySQL server has gone away

I have discovered concerning the MySQL setting, "wait_timeout", though, do I have to modify that on the server at my office or in the remote MySQL server?

Answer 1

I have also faced the same issue however modifying max_allowed_packet in the my.ini/my.cnf file under [mysqld] made it work.

Add this below line:

max_allowed_packet=500M

Then you restart the MySQL service when you are done.

Sign up for the SQL Course by Intellipaat fast, to Learn SQL concepts in detail and get certified.