MySQL: Resolving "Lost connection to MySQL server during query" Error
To resolve the "Lost connection to MySQL server during query" error, please follow the steps below:
- Increase the "Command Timeout" value for your MySQL connection:
- Go to the Connections page and select your MySQL connection.
- Click Edit.
- In the connection editor, go to Advanced, then increase the value for the Command Timeout property.
- Also, increase the following parameters on your MySQL server:
max_allowed_packet
net_read_timeout
net_write_timeout