Brian Reichert wrote:
>
> On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
> > When I try to do a mysqldump on the localhost, I get an out-of-memory
> > error:
> >
> > # mysqldump -uroot -proot customer audit_trail_271
> > mysqldump: Out of memory (Needed 8164 bytes)
> > mysqldump: Got error: 2008: MySQL client run out of memory
>
> Sorry about a rely to myself; on a lark, I did some exploring, and
> the use of the '--opt' flag made the difference. What is that
> [not] doing, that changed the behavior of eveything?
>
--opt (and -q) force the data to go directly to standard out.
without either of those it goes to RAM first. --opt also does
some other stuff you may or may not want, check the manual
for details on that.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
