Paul Walker on 13 Jan 2012 10:11:03 -0800

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

[PLUG] mysql backup via cron running into trouble

I've got this in my crontab
* 12 * * * mysqldump -u root -password --all-databases > /srv/www/sql-backups/$(date +\%y\%m\%d).sql

Then I do some manual cleanup every couple weeks... it works for now. I would expect this to just run the dump, create the file, and that's it... I'm getting tons of errors like this:

mysqldump: Couldn't execute 'show fields from `contact`': Out of resources when opening file '/tmp/#sql_242d_1.MYI' (Errcode: 24) (23)

and everything grinds to a halt... what's the big deal here?

Philadelphia Linux Users Group         --
Announcements -
General Discussion  --