> Fraser MacKenzie wrote:
> > Use --big-tables whhen you startup mysqld
> > Fraser
> > On Wed, 5 May 1999, glen wrote:
> > > i have database table which filesize is 550mb and around 5000000 records
> > >
> > > and free system memory about 400mb, including swap space.
> > > when trying to mysqldump that table then mysqldump fails with error
> > >
> > > mysqldump: Out of memory (Needed 8164 bytes)
> > > mysqldump: Got error: 2008: MySQL client run out of memory
> no the problem is that CLIENT runs out of memory, that is mysqldump in this
> i don't get it why mysqldump needs so much memory, there's no sorting or
Your problem is, that mysqldump normally caches the results it produces.
You have to use the --quick option, to prevent this.