Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

SQL Error (2013):

lolip's profile image lolip posted 3 months ago in General Permalink

Hi, I´m trying to load a query over a 80GB table but after 3 hours the process stops with the following error message: SQL Error (2013): lost connection to MySQL server during query.

I am using HeidiSQL version 11.3.0.6295 (64bit) in Windows v10

Any idea to load this huge table? Thank you!

bing's profile image bing posted 3 months ago Permalink

Wow, that's a large file. I don't think I'd try to use any kind of GUI for importing that, I'd rather just type the command in MySQL directly (LOAD DATA INFILE is your friend).

Apart from that, check your my.ini/my.cnf what have you for

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_wait_timeout

lolip's profile image lolip posted 3 months ago Permalink

Thank you bing! I really appreciate it! What about if I need to read 100 rows instead of the full table? Does HeidiSQL needs to read the full table prior to show the 100 rows? Will the timeout appear if I use LIMIT 100? Thank you!

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.