How to Solve 'Lost connection to MySQL server during query' Error Code 2013?

Resolving Lost Connection to MySQL Server During Query

Question:

While importing data from a large CSV file to a MySQL table, users may encounter an error code 2013: "Lost connection to MySQL server during query." This issue typically arises when queries are executed remotely from a Ubuntu machine to a Windows server.

Possible Solutions:

To address this problem, consider the following two solutions:

1. Adjust max_allowed_packet

Modify the [mysqld] section of your my.cnf or my.ini file by adding the line:

max_allowed_packet=32M

Adjust the value as necessary based on the existing database size.

2. Import the Data via Command Line

If adjusting max_allowed_packet does not resolve the issue, try importing the data using the following command:

mysql -u <user> --password=<password> <database name> <file_to_import

Replace <user>, <password>, <database name>, and <file_to_import> with the appropriate values.

The above is the detailed content of How to Solve 'Lost connection to MySQL server during query' Error Code 2013?. For more information, please follow other related articles on the PHP Chinese website!