Bug #73738 load data local infile produces ERROR 2013 from remote host
Submitted: 27 Aug 2014 7:43 Modified: 27 Aug 2014 11:14
Reporter: Gisela Ellinghaus Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.56 OS:Linux
Assigned to: CPU Architecture:Any

[27 Aug 2014 7:43] Gisela Ellinghaus 
Description:
We load data from a remote host ( -h option) into a table. The table is of type innodb.

It worked fine until yesterday. The innodb-data-file reached the 200 M size defined in my.cnf (max). We changed the entry to "innodb_data_file_path=ibdata1:50M:autoextend". Since then, we are able to load the data on the local host, where mysql is running, but no more from the remote host.

Errormessage:
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query

How to repeat:
The problem always occur
[27 Aug 2014 9:23] MySQL Verification Team 
Thank you for the report.

Please try to increase net_read_timeout and net_write_timeout if they are at default and see if that helps.

Also, version 5.0.56 is old and many bugs were fixed since. Please upgrade to latest GA versions in 5.5/5.6, try with it and if problem still exists send us output of SHOW VARIABLES LIKE '%timeout%' and server error log file.
[27 Aug 2014 11:14] Gisela Ellinghaus 
Thank you, it works now