MySQL Forums
Forum List  »  Newbie

Re: ERROR 2013 (HY000) while importing large mysql dump file
Posted by: Rick James
Date: April 11, 2009 10:41PM

You may have two problems.

Timeout --
SET @@GLOBAL.wait_timeout = 86400; # one day
SET @@GLOBAL.interactive_timeout = 86400; # one day
and re-connect to the server.

Out of memory --
Increase the settings of a couple of things, perhaps
bulk_insert_buffer_size
max_allowed_packet
And maybe some more. Read the docs.

Also, search for any value near 512M in
SHOW VARIABLES;

Does the operating system limit how much RAM it will let a process have? 32-bit FreeBSD had a default of 512MB.

Change the settings back after you finish the load.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.