SQL Issues

Last reviewed: June 2, 2026

danger

Error:

SQL Error (2013): Lost connection to server during query Notice: You can disable the "Stop on errors in batch mode" option to ignore such errors"

tip

Solution:

Fix: Run this query in your HeidiSQL query-tab

SET GLOBAL max_allowed_packet=1073741824;
SET GLOBAL wait_timeout = 3500;
SET GLOBAL net_read_timeout = 3500;
SET GLOBAL connect_timeout = 3500;

info

After you're done importing the file, run this other query to revert back to default.

SET GLOBAL max_allowed_packet=1073741824;
SET GLOBAL wait_timeout = 600;
SET GLOBAL net_read_timeout = 600;
SET GLOBAL connect_timeout = 600;

danger

We do not offer any support other than what is found on this guide. Please do not ask us for any support.