469,927 Members | 1,795 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

mysqldump out of memory

I have some some large tables, 30 mil rows, some rows has long blogs
size (300M). I used mysqldump -q to dump it, but i still get out of
memory error.

Any suggestion?
Jul 19 '05 #1
3 7489
Here is the error message:
/usr/local/mysql/bin/mysqldump: Out of memory (Needed 260115456 bytes)

Here is my mysqldump --print-defaults
--port=3306 --socket=/tmp/mysql.sock --quick
--set-variable=max_allowed_packet=512M
--set-variable=net_buffer_length=400M

I am using innodb tables. The mysql server version is:
mysql Ver 12.21 Distrib 4.0.15, for ibm-aix5.1.0.0 (powerpc)
g0***@yahoo.com (g00g0) wrote in message news:<f5************************@posting.google.co m>...
I have some some large tables, 30 mil rows, some rows has long blogs
size (300M). I used mysqldump -q to dump it, but i still get out of
memory error.

Any suggestion?

Jul 19 '05 #2
Here is the error message:
/usr/local/mysql/bin/mysqldump: Out of memory (Needed 260115456 bytes)

Here is my mysqldump --print-defaults
--port=3306 --socket=/tmp/mysql.sock --quick
--set-variable=max_allowed_packet=512M
--set-variable=net_buffer_length=400M

I am using innodb tables. The mysql server version is:
mysql Ver 12.21 Distrib 4.0.15, for ibm-aix5.1.0.0 (powerpc)
g0***@yahoo.com (g00g0) wrote in message news:<f5************************@posting.google.co m>...
I have some some large tables, 30 mil rows, some rows has long blogs
size (300M). I used mysqldump -q to dump it, but i still get out of
memory error.

Any suggestion?

Jul 19 '05 #3
Here is the error message:
/usr/local/mysql/bin/mysqldump: Out of memory (Needed 260115456 bytes)

Here is my mysqldump --print-defaults
--port=3306 --socket=/tmp/mysql.sock --quick
--set-variable=max_allowed_packet=512M
--set-variable=net_buffer_length=400M

I am using innodb tables. The mysql server version is:
mysql Ver 12.21 Distrib 4.0.15, for ibm-aix5.1.0.0 (powerpc)
g0***@yahoo.com (g00g0) wrote in message news:<f5************************@posting.google.co m>...
I have some some large tables, 30 mil rows, some rows has long blogs
size (300M). I used mysqldump -q to dump it, but i still get out of
memory error.

Any suggestion?

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mangina | last post: by
reply views Thread by g00g0 | last post: by
reply views Thread by Thiko | last post: by
7 posts views Thread by Adam Smith | last post: by
reply views Thread by mcstayinskool | last post: by
1 post views Thread by Greg.Harabedian | last post: by
6 posts views Thread by Todd Cary | last post: by
6 posts views Thread by Antoni | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.