[mythtv-users] 5 Db rotate

[Stephen Worthington]

On Sat, 22 Nov 2014 09:23:31 -0500, you wrote:

>Greetings Mythizens, I remember in previous setups having the 5 latest Db
>backups kept in /var/lib/mythtv/db_backups. That's not happening now, I am
>getting mythbuntu backups as a result of MCC, but they don't rotate, I go
>in and cull once in a while. From looking at the wiki I have the backup and
>restore scripts in /usr/share/mythtv, and I echo'd the location I want the
>backups to land in, my question is how do I set the frequency to daily and
>select the time? IIRC this used to happen without a cron job.
>Sort of related the box doesn't wakeup for Db backups or MFDB's is this
>even possible?     TIA Daryl

In Mythbuntu, the backups are normally done weekly by a cron job that
is installed by one of the Mythbuntu packages:

  /etc/cron.weekly/mythtv-database

That file contains this in 14.04:

#!/bin/sh
# /etc/cron.weekly/mythtv-database script - check and backup
mythconverg tables
# Copyright 2005/12/02 2006/10/08 Paul Andreassen
#                      2010 Mario Limonciello

set -e -u

DBNAME="mythconverg"
DEBIAN="--defaults-extra-file=/etc/mysql/debian.cnf"

/usr/bin/mysqlcheck $DEBIAN -s $DBNAME

/usr/share/mythtv/mythconverg_backup.pl

/usr/bin/logger -p daemon.info -i -t${0##*/} "$DBNAME checked and
backedup."

# End of file.


I have put a modified copy of that file in /etc/cron.daily to also do
daily backups to another PC on my network:

#!/bin/sh
# /etc/cron.weekly/mythtv-database script - check and backup
mythconverg tables
# Copyright 2005/12/02 2006/10/08 Paul Andreassen
#                      2010 Mario Limonciello

# JSW Modified for /etc/cron.daily backups to a network drive.

set -e -u

DBNAME="mythconverg"
DEBIAN="--defaults-extra-file=/etc/mysql/debian.cnf"

# Debug:
/usr/bin/logger -p daemon.info -i -t${0##*/} "Debug: $DBNAME
cron.daily checking started."

/usr/bin/mysqlcheck $DEBIAN -s $DBNAME

# Debug:
/usr/bin/logger -p daemon.info -i -t${0##*/} "Debug: $DBNAME
cron.daily checking finished, backup starting."

/usr/share/mythtv/mythconverg_backup.pl --directory
"/mnt/savaidh/ldrive/Backups/MythTV_db_backup/mypvr"

/usr/bin/logger -p daemon.info -i -t${0##*/} "$DBNAME checked and
backedup."

# End of file.


The real work is done by the /usr/share/mythtv/mythconverg_backup.pl
script, which is where the default rotation is set.  Use

  /usr/share/mythtv/mythconverg_backup.pl --help

and 

  /usr/share/mythtv/mythconverg_backup.pl --help --help

for help.  It looks like there is a --rotate option to override the
default value.