Apply OS: Windows, Mac, Linux, iOS
Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
The error you received "Error: 2013 Lost connection to MySQL server during query" is returned by MySQL and is due to server variables settings.
For more details on how to set the server variable to avoid this error, please refer to MySQL Manual - http://dev.mysql.com/doc/refman/5.5/en/gone-away.html
Mac version 10.x or above
If you receive "Lost connection to server during query" error when running long query, please try:
- Control-click your connection and choose Connection Properties/Edit Connection.
- Under Advanced tab, set the Socket Timeout (sec) to a larger value.