1 of 1 Servers
Search
⌃K
📶

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.