SQL Error (2013):

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!

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

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!