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

[Carl Johnson <cjohnson19791979@gmail.com>]

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 <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