Geoff,
Thanks for the links to your script. Also, the rddbcheck did the
trick. Fixed it right up, and I can now do backups from within RDAdmin
again.
The database wasn't very large to begin with, but is several years old.
Questions still remain though:
Is is safe to have multiple simultaneous db accesses happening at once?
Is it even allowed? Again, this is for clock generation/modifications
at the same time as traffic log generation/editing from remote Windows
workstations.
Thanks!
-Alan
On 11/25/2016 1:01 PM, Geoff Barkman wrote:
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]
<mailto:[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]
<mailto:[email protected]>
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
<http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev>
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
