I suggest that the mysql backups have the "-q" flag added to dramatically reduce the memory required for large table backups.
One of my databases started tossing this error during the daily virtualmin backups:
usr/bin/mysqldump: Out of memory (Needed 8164 bytes)
/usr/bin/mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server
I did a bit of research and found this blog post that suggests using the "-q" flag: http://jeremy.zawodny.com/blog/archives/000690.html
I hacked the flag into the [webmin root]/mysql/feature-mysql.pl file and now the db backs up OK.
My situation might be different than most. This is my Virtuozzo based VPS and it doesn't have a "normal" swap file. Anyway, it's a small change with very few downsides and I think it should be the default setting. If not, I'll just hack the file after every update.
Thanks again for Webmin. I don't know how I'd manage my VPS without it.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.