0 votes
1 view
in SQL by (6.1k points)

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?

1 Answer

0 votes
by (12.7k points)

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.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...