List:General Discussion« Previous MessageNext Message »
From:mailing@securitylabs.it Date:March 1 2012 10:09am
Subject:Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
View as plain text  
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
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