MySQL server is gone

Question

I am trying to insert data of 50,000 rows with a single request, so the server is leaving. I tried to change max_allowed_packet but did not change. Any advice.

Thanks in advance

Answer 1

Have you checked mysqls wait_timeout timeout? Also, what do you use to import records (script, sql editor, command line)? Php forexample uses its own connect_timeout, set in php.ini, which will cause the error you see.

Answer 2

, , , - , , , . - , , 25-100 .

Answer 3

There, find wait_timeout and some mysql_ping and a few more suggestions.

Answer 4

I set max_allowed_packet = 64 in my.ini and restarted the server. Now it works fine. Thank you all for your help.