If you did not work directly on mysql server (login by mysql command), please try this. Using script (PHP, ...) may lose connection, as my experience.
Best --- On Mon, 3/5/12, Singer X.J. Wang <[email protected]> wrote: > From: Singer X.J. Wang <[email protected]> > Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query > To: "javad bakhshi" <[email protected]> > Cc: "[email protected]" <[email protected]> > Date: Monday, March 5, 2012, 10:40 PM > Checking your firewall settings.. > > S > > > On Mon, Mar 5, 2012 at 08:39, javad bakhshi <[email protected]> > 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: "[email protected]" > <[email protected]> > > To: [email protected] > > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
