MySQL Import sql file times error code:2013-lost connection to MySQL server during query

MySQL Sometimes we import SQL file, file too large, cause error code:2013-lost connection to MySQL server during query such errors

Do the following:

[SQL]View PlainCopyPrint?

1. SHOW GLOBAL VARIABLES like   '%timeout ';
2. SET   GLOBAL net_write_timeout=28800;
3. SET   GLOBAL net_read_timeout=100;
4. SET   GLOBAL connect_timeout=100;
5. SET   GLOBAL long_query_time=100;
6. SET   GLOBAL max_allowed_packet=5242880;

March 19, 2015 again, this problem was encountered.

Modify My.ini

Max_allowed_packet = 500M

All right

Teach you how to find My.ini files in your system

Start running services.msc The service found MySQL point attribute has an executable file path, always looking back, will appear my.ini the specific address of this file

MySQL Import sql file times error code:2013-lost connection to MySQL server during query