Are you using the --quick option?
--quick, -q
This option is useful for dumping large tables. It forces mysqldump to
retrieve rows for a table from the server a row at a time rather than
retrieving the entire row set and buffering it in memory before writing
it out.
thanks both - that did t
To: mysql@lists.mysql.com
Subject: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of
Memory
Hi
Trying to dump a complete db where 1 of the tables contains about 88
million rows - When the dump runs on the command line the following
error is thrown
mysqldump: Out of memory (Needed 3543
Hi Tom,
Use -q option on mysqldump ;)
-q Won't buffer query, It will dump directly to stdout.
--Praj
On Tue, 14 Mar 2006 11:56:42 +
Tom Brown <[EMAIL PROTECTED]> wrote:
> Hi
>
> Trying to dump a complete db where 1 of the tables contains about 88
> million rows - When the dump runs o
Hi
Trying to dump a complete db where 1 of the tables contains about 88
million rows - When the dump runs on the command line the following
error is thrown
mysqldump: Out of memory (Needed 3543176 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when
retrieving data from ser
