-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 To expand on Wayne's excellent idea a bit, I've created a more-or-less generic MySQL database backup script. You can see it and download it from https://github.com/opensourceradio/ram/blob/master/usr/local/bin/database-backup (requires the companion function library "zsh-functions" in the same directory).
And I back run this twice per day with the crontab entry: # at 12:08pm and 6:08pm every day back up the database and save the output in the database-backup.log file 08 12,18 * * * /usr/local/bin/database-backup > /var/tmp/database-backup.log 2>&1 Hope this helps! ~David Klann On 03/01/2016 02:07 AM, Wayne Merricks wrote: > You can use Rivendell to automate MySQL backups but I'm an old fogey when it > comes to MySQL and I do this: > > #!/bin/bash > #Backup MySQL and copy somewhere > mysqldump --compress -u rduser -pletmein Rivendell | gzip -c9 > ~/backups/rivendell.`date +"%Y-%m-%d`.gz > > With a bit of mount point or scp magic you can copy this zipped sql dump to somewhere safe. Then just add the script to cron: > > 15 21 * * * /home/rduser/scripts/backup_database.sh > > Having standard MySQL and a directory with all the audio in was one of the major deciding factors in us switching to Riv a few years ago now. > > Regards, > > Wayne > > > > On 29/02/16 22:34, Tom Van Gorkom wrote: >> I kept scouring the internet for clues since this was so strange... Supposedly this was to be fixed in RD 2.x but another foreign language station found that when they add symbols or accents to event names that it wipes out the clock events almost across the board. Weird. I had a "+" in one name and it wiped the events. Removing it restored it all. Whew... would have been a lot of work to restore all the clocks. >> >> Tom Van Gorkom >> Radio Esperanza Engineering, KRIO AM/FM, KOIR FM >> Office: 956-380-8150 >> Cell: 865-803-7427 >> >> Rio Grande Bible Institute >> 4300 S US Hwy 281 >> Edinburg, TX 78539 >> >> >> _______________________________________________ >> 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iF4EAREIAAYFAlbVrOIACgkQZtxZ++32cNigzgEAicuKyd2o+tAZcvGxruTnpsRq URpdI8mFZe+RMfGlBE8A/iHHXIy5cYYdIEmEiLZ+32hXRyD3MiZ4URbeLAiPgcwr =Kv0d -----END PGP SIGNATURE----- _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
