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?