List:General Discussion« Previous MessageNext Message »
From:Blog Tieng Viet Date:March 7 2012 2:49pm
Subject:Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
View as plain text  
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 <wang@stripped> wrote:

> From: Singer X.J. Wang <wang@stripped>
> Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
> To: "javad bakhshi" <javadbakhshi@stripped>
> Cc: "mysql@stripped" <mysql@stripped>
> Date: Monday, March 5, 2012, 10:40 PM
> Checking your firewall settings..
> 
> S
> 
> 
> On Mon, Mar 5, 2012 at 08:39, javad bakhshi <javadbakhshi@stripped>
> 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: "mailing@stripped"
> <mailing@stripped>
> > To: mysql@stripped
> > 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
> 
Thread
ERROR 2013 (HY000): Lost connection to MySQL server during queryjavad bakhshi1 Mar
  • Re: ERROR 2013 (HY000): Lost connection to MySQL server during querymailing@securitylabs.it1 Mar
    • Re: ERROR 2013 (HY000): Lost connection to MySQL server during queryjavad bakhshi5 Mar
      • Re: ERROR 2013 (HY000): Lost connection to MySQL server during querySinger X.J. Wang5 Mar
        • Re: ERROR 2013 (HY000): Lost connection to MySQL server during queryBlog Tieng Viet7 Mar