Hi, Still have the same problem and changing connect_timeout didn't help. Any other Ideas? Is there even any solution to this? Best regards, Javad Bakhshi,
________________________________ From: "mail...@securitylabs.it" <mail...@securitylabs.it> To: mysql@lists.mysql.com Sent: Thursday, March 1, 2012 11:09 AM Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query Il 01/03/2012 11:03, javad bakhshi ha scritto: > Hi, > > I am trying to load data into my table from a very large file but after some > time I get this error: > > ERROR 2013 (HY000): Lost connection to MySQL server during query > > > My file size is around 4G and I have 220M lines in my file which have to be > loaded in to my table. I have 10 of these files which have to loaded in the > same table. My MySQL version is 5.1.59, I have changed the > max_allowed_packet to 346030080. > > any ideas how I can solve this problem? > Best regards, > Javad Bakhshi, In order to resolve the problem you may need to increase these two values in mysql.ini or my.cnf, and restart mysql: wait_timeout = 28800 connect_timeout = 28800 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
