This example is to backup the videometadata table in mythconverg, but could be adapted to backup anything.
I use an external usb disk to hold my video's. If it's unmounted when the video manager is started all the video info is lost. I decided to write a script to back it up daily, and keep multiple copies around so I could always find a good one. Then I came across a tip to use logrotate to do this. Just add the code below to /etc/logrotate.conf and you'll have two weeks worth (due to the rotate 14 and daily lines) of backups of the table. They even get zipped up to save space.
Since it saved my butt today, I decided it was worthy of posting.
Code:
# system-specific logs may be configured here
# mythtv videometadata table backup
/var/backups/videometadata.sql {
daily
rotate 14
missingok
compress
postrotate
/usr/bin/mysqldump --opt -umythtv -pmythtv mythconverg videometadata > /var/backups/videometadata.sql
endscript
}
# mythtv videometadata table backup
/var/backups/videometadata.sql {
daily
rotate 14
missingok
compress
postrotate
/usr/bin/mysqldump --opt -umythtv -pmythtv mythconverg videometadata > /var/backups/videometadata.sql
endscript
}