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

[Mike <coolgeek1987@yahoo.com>]

Have you seen this?

http://stackoverflow.com/questions/502545/too-many-open-files-error-on-ubuntu-8-04

Message: 1
Date: Fri, 13 Jan 2012 13:10:57 -0500
From: Paul Walker <starsinmypockets@gmail.com>
Subject: [PLUG] mysql backup via cron running into trouble
To: "Philadelphia Linux User's Group Discussion List"
    <plug@lists.phillylinux.org>
Message-ID:
    <CAB_kf=D3M=+1ZsAnquh9Sk_kUZPAAKHRit3js76ZREU=Ujb=-A@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.netisland.net/pipermail/plug/attachments/20120113/275e1303/attachment.html>

___________________________________________________________________________
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