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