Hi, As a stop gap, have you considered using cron to back the database up? Its easy to do:
Create a script file somewhere accessible (/home/myuser is as good as anywhere) that has the following: #!/bin/sh mysqldump -urduser -psuper_secret_password --compress Rivendell | gzip -c9 > /tmp/rivendell.`date +"%Y-%m-%d"`.gz Change the -urduser to whatever user name you use and -psuper_secret_password to whatever password you use. Finally at the end is /tmp/rivendell etc. This will save the output to /tmp/rivendell.2013-01-13.gz, amend /tmp as necessary. I'll save it to /home/rivendelluser/backup.sh for this example. Once thats done, chmod +x the file and go into crontab: We'll be making this script run every wednesday at 9:15pm: crontab -e at the bottom add: 15 21 * * 3 /home/rivendelluser/backup.sh If you don't want to wait for cron you can run the sh file manually with the usual ./backup.sh Hope this helps until you figure out the cause, Wayne -----Original Message----- From: [email protected] on behalf of Geoff Barkman Sent: Sun 13/01/2013 21:22 To: User discussion about the Rivendell Radio Automation System Subject: Re: [RDD] Rivendell 1.72 Ubuntu 10.04 "Unable to create backup!" Hi Phil I get a error message. Access denied for user 'root'@'localhost' (using password NO) when trying to connect On Mon, Jan 14, 2013 at 10:04 AM, Phil Jennings <[email protected]> wrote: > Have you tried from terminal as root? > > #mysqldump --single Rivendell > /file/path.sql > > > Phil Jennings > Calvary Radio > 219-707-0075 > > Geoff Barkman <[email protected]> wrote: > >>Hi There >>I'm getting a rather obscure message when I try to use the rdadmin >>Backup tool for making a backup of my database. >> >>I had my database set to back up every week on a particular day... and >>I noticed that the weekly backup file was only 805 bytes in size >>instead of the usual 49000kb that it normally is. So I thought I'd try >>the rdadmin tool. And get the error message box "Unable to create >>backup!". >>Any idea where to start checking so I can back up the system again? >>I do have mysql admin installed so i can log in using that... but i >>guess something is at fault with the database. >> >>Many thanks >>Geoff >>_______________________________________________ >>Rivendell-dev mailing list >>[email protected] >>http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ####################### Scanned by MailMarshal ####################### ############ Attention: The information contained in this message is confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. Christian Vision or any of its subsidiaries will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on. Please note that we reserve the right to monitor and read any e-mails sent or received by the company under the Telecommunications (Lawful Business Practice) (Interception of Communications) Regulation 2000. Christian Vision is registered in England as a limited company 2842414 and as a charity 1031031 ############
<<winmail.dat>>
_______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
