From: javad bakhshi Date: March 5 2012 1:39pm Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query List-Archive: http://lists.mysql.com/mysql/226937 Message-Id: <1330954750.50989.YahooMailNeo@web125701.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="479758653-1336199894-1330954750=:50989" --479758653-1336199894-1330954750=:50989 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0A=0AStill have the same problem and changing=A0connect_timeout=A0didn'= t help.=A0=0AAny other Ideas? Is there even any solution to this?=0A=A0=0AB= est regards,=0AJavad Bakhshi,=0A=0A=0A________________________________=0A F= rom: "mailing@stripped" =0ATo: mysql@lists.= mysql.com =0ASent: Thursday, March 1, 2012 11:09 AM=0ASubject: Re: ERROR 20= 13 (HY000): Lost connection to MySQL server during query=0A =0AIl 01/03/201= 2 11:03, javad bakhshi ha scritto:=0A> Hi,=0A> =0A> I am trying to load dat= a into my table from a very large file but after some time I get this error= :=0A> =0A> ERROR 2013 (HY000): Lost connection to MySQL server during query= =0A> =0A> =0A> My file size is around 4G and I have 220M lines in my file w= hich 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= =A0 max_allowed_packet to 346030080.=0A> =0A> any ideas how I can solve thi= s problem?=0A>=A0 Best regards,=0A> Javad Bakhshi,=0AIn order to resolve t= he problem you may need to increase these two values in mysql.ini or my.cnf= , and restart mysql:=0A=0Await_timeout =3D 28800=0Aconnect_timeout =3D 2880= 0=0A=0A-- MySQL General Mailing List=0AFor list archives: http://lists.mysq= l.com/mysql=0ATo unsubscribe:=A0 =A0 http://lists.mysql.com/mysql --479758653-1336199894-1330954750=:50989--