Debug School

rakesh kumar
rakesh kumar

Posted on

ERROR:MySQL server has gone away

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
Enter fullscreen mode Exit fullscreen mode

Image description

Solution:
go to my.ini file

Image description

edit and increase size of [mysqld]
max_allowed_packet=16M

Image description

reference:
mysql-error-2006-mysql-server-has-gone-away

Top comments (0)