Hi Tim,
I seem to remember running into something like this. The my.cnf file has an entry - open-files-limit - which I think I bumped up to 8192, I believe the default is much lower. In my system this is in /etc/mysql, but your OS may put it somewhere else. I think you have to restart the mysql server for this to take effect. Hope this helps, Todd Baker From: rivendell-dev-boun...@lists.rivendellaudio.org [mailto:rivendell-dev-boun...@lists.rivendellaudio.org] On Behalf Of Tim Camp Sent: Monday, September 12, 2011 10:48 AM To: User discussion about the Rivendell Radio Automation System Subject: [RDD] mysql backup Greetings, Recently moved our mysql server to a new box, Running Rivendell 1.72 Problem is I couldn't do a backup of the database from Rivendell, so I tried to just set up a daily backup with mysqldump, however it errors out with a erron 24, seems there is a problem with lock tables, I have doublecheck mysql permissions on this and root "who is running the cron job" has correct permissions, seems to be a problem with too many open files as it gets about halfway through the backup and crashes. I can do a manual backup using mysql-administrator or mysql-workbench with no problem, but I really need a automatic solution. I have found on google a bunch of references to this max files issue, but don't find that setting in my config files. Anyone crossed this bridge before? Cheers -- Tim Camp Director of Operations/Programming Dot Com Plus L.L.C. dba WZEW-FM WNSP-FM Mobile, Al.
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
