mysqldump -u root -p Rivendell --lock-tables=false >/home/put your login name here/backupname.sql
should do the business took a while to find the problem in the logfile but seems to work every time i run it regards Robert On 13/09/2011 02:48, Tim Camp wrote: > 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 -- Robert Jeffares Big Valley Radio Thames New Zealand _______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev