MySQL Forums
Forum List  »  Backup

mysqldump error 5 Out of memory
Posted by: Tyler Poland
Date: January 05, 2006 02:46PM

When I try to dump one of our tables as a part of our automated backup script I get the error message "Error 5: Out of memory (Needed 60536232 bytes) when dumping table `<tablename>` at row: 53147".

The specifics of the implementation are below:

Windows 2003 Enterprise Edition
24 GB physical memory
MySQL 4.1.9-nt compiled for AWE support
Dual XEON 2.8 GHz

my.ini [mysqldump] section

Table details
Data_length: 7826571264
Index_length: 188448768

Record details
Row before failure row in error contains a longtext of 383Kb
Row identified as failure row contains a longtext of 166Kb
Row after failure row in error contains a longtext of 19705Kb

Dump Command
mysqldump --u={uname} -p{password} --port={portnumber} --opt --skip-lock-tables --single-transaction {database} > D:\{path to sql file}

I have tried several variations of max_allowed_packet, net_buffer_length, as well as skip_extended_insert, skip_quick, -f. I have also run the command directly on the specify table that is failing, it fails in the same place.

Any assistance would be greatly appreciated.

Thank you,

Options: ReplyQuote

Written By
mysqldump error 5 Out of memory
January 05, 2006 02:46PM
January 09, 2006 04:37PM
January 26, 2006 08:37AM
February 08, 2006 05:20AM
February 09, 2006 03:40AM

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.