Hi Alan How old is the Database? I ran into problems when my system had been running 2 or 3 years. I have a cronjob set up to automaticly back up the database every week at the same time and append the current date / time to the filename so a sequential backup is kept. I think I fixed it by running rddbcheck from a commandline. It fixed up the database and let me make database back ups in the normal way using rdadmin. Running rddbcheck shrunk the db backup sql file from 45 mb down to about 10 mb.
Here is my script and a link to my blog that hosts it. http://geofffromdunedin.blogspot.co.nz/2010/12/automatically-backup-rivendell-database.html NOTE If sharing created files with windows users Colons eg : cannot be in filenames #I suggest doing the date variable creation like this. currentdate=`date +%F-%H.%M.%S` Instead of like this currentdate=`date +%F-%X` Note I found that sometimes the Rivendell macros crash rdairplay so I now run from a command line the following script..... #!/bin/bash currentdate=`date +%F-%X` echo $currentdate mysqldump -u rduser -pletmein --lock-tables=false Rivendell > /home/geoff/rivendell-backup/RD-$currentdate.sql You can set up this macro to run daily weekly or whenever. I hope this helps you automate the process. Many thanks Geoff Barkman On Sat, Nov 26, 2016 at 3:19 AM, Alan Smith <[email protected]> wrote: > Been a while since I've posted to the group. > > I currently still only have a single RD system running out on the other > side of the country, so I don't get a chance to "fiddle" with it much. > > I decided I had better do a database backup since its been a long while, > and using rdadmin when I tried was greeted with "Unable to create > backup!". On some google searching, seems this is a common long-running > issue. I did find a command that allowed me to back it up via the command > line. > > The reason for my post is I am wanted to install RD for a single AM > station that I do some side work for. My plan is going to make heavy use > of running RDLogEdit/RDLogManager from a couple Windows machines. So my > questions: > > 1) Does this "bug" that crops up that won't allow DB backups from within > RD also affect the ability to remotely access the DB from RD modules > running on Win platforms? > > 2) Can you have simultaneous access to the DB from multiple Win > platforms? I imagine the PD will want to create clocks and such while > Traffic will be working on logs. > > Thanks! > > -Alan > > PS This is on the latest appliance via the Parvel website. Also, database > backup in rdadmin used to work fine. It just "broke" one day, and since > its been a while I'm not sure when or why. > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
