List:General Discussion« Previous MessageNext Message »
From:javad bakhshi Date:March 5 2012 1:39pm
Subject:Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
View as plain text  
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
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