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
quick
max_allowed_packet=64M

Table details
Data_length: 7826571264
Index_length: 188448768
Type: INNODB

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


Subject
Views
Written By
Posted
mysqldump error 5 Out of memory
25106
January 05, 2006 02:46PM
13220
January 09, 2006 04:37PM
9930
January 26, 2006 08:37AM
10229
February 08, 2006 05:20AM
9072
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.