PDA

View Full Version : Mysqldump Out of Memory?


propheci
Tue 16th Oct '01, 9:27pm
i get this when trying to dump my forum:

mysqldump: Out of memory (Needed 25520 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server

is that talking about disk drive space or actual ram? and does anyone know how to fix it?

thanks.

eva2000
Tue 16th Oct '01, 9:31pm
are you using

1. vB's backup
2. phpmyadmin
3. telnet to use mysqldump

if using mysqldump use --opt to prevent mysqldump from loading the entire mysql database into memory prior to dumping

so

mysqldump --opt -u username -p databasename > /path/to/dump.sql

propheci
Tue 16th Oct '01, 9:35pm
i was using telnet. your answer fixed everything. thank you very much!

eva2000
Tue 16th Oct '01, 9:39pm
Originally posted by propheci
i was using telnet. your answer fixed everything. thank you very much! no probs :D

mcncyo
Mon 22nd Oct '01, 10:27am
you might want to upgrade your ram.