PROBLEM
I'm 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 following error:
2006, MySQL server has gone away
I've heard about the MySQL setting, wait_timeout
ERROR 2006 (HY000) at line 5620: MySQL server has gone away
Solution:
go to my.ini file
edit and increase size of [mysqld]
max_allowed_packet=16M
reference:
mysql-error-2006-mysql-server-has-gone-away
Top comments (0)