I have been using this method since I started. I always have had issues using rdadmin. I think it has something to do with the size of the database (I'm running 6 different stations (services) with one server). Anyway, this has always worked for me so, if it ain't broke... I have cron jobs that back up my database every night saving it as the name of the current day of the week. That way I always have the last 7 days of databases. This is just how I do things. I try to keep things as simple as possible as I'm not a Linux guru by any stretch of the imagination.. :-) Glad I could help!
Thanks, Phil Jennings Calvary Radio 219-707-0075 Geoff Barkman <[email protected]> wrote: >Hi Phil > > #mysqldump -u root -p rootpass --single Rivendell > /file/path.SQL > >That created a back up. I wonder why I can't create it in rdadmin? >I created a backup program a while back using the Rivendell DB! macro >and then renaming the backup file so that it has the current date as >part of the file name. It was working so reliably I hadn't bothered to >check it since last year. > >On Mon, Jan 14, 2013 at 11:15 AM, Phil Jennings ><[email protected]> wrote: >> Try this. >> >> #mysqldump -u root -p rootpass --single Rivendell > /file/path.SQL >> >> >> Phil Jennings >> Calvary Radio >> 219-707-0075 >> >> Geoff Barkman <[email protected]> wrote: >> >>>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 >>> >> _______________________________________________ >> 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
