Carl Johnson on 13 Jan 2012 10:16:03 -0800

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

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

Is mysql running when you do that? You might be hitting a transaction limit when mysqldump runs.

Sent from my Motorola DynaTAC 8000x

Paul Walker <> 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
>I'm getting tons of errors like this:
>mysqldump: Couldn't execute 'show fields from `contact`': Out of
>> 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  --  

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