|
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
|
- From: Paul Walker <starsinmypockets@gmail.com>
- To: "Philadelphia Linux User's Group Discussion List" <plug@lists.phillylinux.org>
- Subject: [PLUG] mysql backup via cron running into trouble
- Date: Fri, 13 Jan 2012 13:10:57 -0500
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; bh=rQ+6Sj8LcF6gxCl8h3h4N4zXRJmgxp+k+9OGtFpyH4M=; b=h+j7gk3OmkvxhVx170ZMvXSWVt3jNkxrkrpK8QJV4E7ZW4JoKlDg2o6npbGQPxAIdr ySb265wIS3YTn0HxLnVWuozLaRa7DCv9CNib+fn2DO4CxTsNtJ3HW6SVCVi/Ce4iOSNr OyceVqiS3VrIPutmIfPxo9e8eL0nPfsOjaf30=
- Reply-to: Philadelphia Linux User's Group Discussion List <plug@lists.phillylinux.org>
- Sender: plug-bounces@lists.phillylinux.org
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