[mythtv-users] Thank you sd Kovacs backup script

Rick ve1gn at nb.sympatico.ca
Sat Nov 24 14:47:24 UTC 2007


Phill Edwards wrote:
>> Thank you sd kovacs!  Your daily backup script that I'm using saved my
>> bacon today.  My mythconverg database became corrupt yesterday (for no
>> apparent reason) and nothing I could do would save it.  Luckily I've
>> been using your script to keep a weeks worth of backups.  The latest
>> backup was only a few hours old so I was back in business in just a few
>> minutes.
> 
> Sounds a great script. Would you mind posting a link to it or to the
> original mailing post about it?
> 
> Regards,
> Phill

I just appended his script to the optimize mythdb script in contrib 
thusly. That way it optimizes the db then backs it up. I also added a 
line at the end to copy the backup to my NAS just for peace of mind.
Thinking about it, I guess you could move the optimize_mythdb.pl script 
out of contrib (because that directory changes everytime there is a new 
version of myth) and just point OPT_MYTHDB at its location.

Rick

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

OPT_MYTHDB='/usr/share/doc/mythtv-docs-0.20.2/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}

# Created on 3/22/2006 by sdkovacs
# Script: mythbackup

BACKFILE="/home/mythtv/mythbackup.`date +%a`.sql.gz"


mysqldump -u root -pyour_password_here mythconverg -c | gzip -c > 
${BACKFILE}
if [ $? -ne "0" ]
then
         echo "Mythtv database backup failed! Exiting..."
         exit 1
fi

cp ${BACKFILE} /htpc/backups


More information about the mythtv-users mailing list