Re: [PLUG] mysql backup via cron running into trouble

[Amir Tahvildaran <amir@mathforum.org>]

I assume you get the same errors when running it manually.  That is, the problem is not related to cron, right?

You might try --skip-lock-tables (at least to see if locking/transactions is part of the problem).

-Amir

On Fri, Jan 13, 2012 at 1:10 PM, Paul Walker <starsinmypockets@gmail.com> wrote:

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?

paul 

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug