SQL Issues

A quick rundown of a few issues you can encounter on SQL.

SQL Error (2013)

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"

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;

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;

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