Re: table too big to dump?

2001-02-08 Thread Brian Reichert
On Wed, Feb 07, 2001 at 05:38:49PM -0600, Dan Nelson wrote: It's probably trying to read the whole table into memory. Try adding "--opt" to the mysqldump commandline. OK, I've had _many_ responses that in effect say 'use -q' (--opt is a superset). It works. Thanks. Dumb question: why isn't

Re: table too big to dump?

2001-02-08 Thread Vivek Khera
"BR" == Brian Reichert [EMAIL PROTECTED] writes: BR When I try to do a mysqldump on the localhost, I get an out-of-memory BR error: BR # mysqldump -uroot -proot customer audit_trail_271 BR mysqldump: Out of memory (Needed 8164 bytes) BR mysqldump: Got error: 2008: MySQL client run out of

table too big to dump?

2001-02-07 Thread Brian Reichert
I apologize if this has been discussed already, but I quick poke at the archives didn't reveal anything. We have a table that iamchk says is fine. We are trying to get an SQL dump of this table. But, we keep getting out-of-memory errors. I've tried several things, all to no avail, and I'm

Re: table too big to dump?

2001-02-07 Thread Brian Reichert
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

Re: table too big to dump?

2001-02-07 Thread Steve Ruby
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

Re: table too big to dump?

2001-02-07 Thread Dan Nelson
In the last episode (Feb 07), Brian Reichert said: I apologize if this has been discussed already, but I quick poke at the archives didn't reveal anything. We have a table that iamchk says is fine. We are trying to get an SQL dump of this table. But, we keep getting out-of-memory errors.