[mythtv-users] Running optmize_mythdb from cron script (ATRPMS base)

[Greg Cope]

Hi All,

I have made a few scripts to run optimize_mythdb from cron daily, and
rotate the logs.

It is for FC4 ATRPMS,

First make it executatble;

chmod 755 /usr/share/doc/mythtv-0.19/contrib/optimize_mythdb.pl

###### optimize_mythdb.sh
#!/bin/sh

OPT_MYTHDB='/usr/share/doc/mythtv-0.19/contrib/optimize_mythdb.pl'
LOG='/var/log/mythtv/optimize_mythdb.log'

echo "Started ${OPT_MYTHDB} on `date`" >> ${LOG}
${OPT_MYTHDB}  >> ${LOG}
echo "Finished  ${OPT_MYTHDB} on `date`" >> ${LOG}

###### cat optimize_mythdb
/var/log/mythtv/optimize_mythdb.log {
    notifempty
    missingok
    compress
    compresscmd /usr/bin/bzip2
    uncompresscmd /usr/bin/bunzip2
    compressext .bz2
    weekly
    rotate 4
}

Alex, if your reading - fancy incorporating it into atrpms?

Greg