Checking your firewall settings.. S
On Mon, Mar 5, 2012 at 08:39, javad bakhshi <javadbakh...@yahoo.com> wrote: > 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 > -- -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
