[mythtv-users] Mysql complains at me

[Ian Forde]

On Thu, 2006-01-26 at 16:00 -0500, shadestalker at gmail.com wrote:
> I still haven't setup regular backups of my db, so I'm inviting
> exactly the above situation on myself.  I acknowledge the possibility
> and responsibility I have to deal with it if it does happen, but the
> fact that mythtv is that way means I won't ever build one and send it
> to my mom.  It's bad enough she has a DVD player.  ;) 

Do the following:

mkdir /var/lib/backups

Then put this into a cron job (modifying username and destination as needed):

#!/bin/sh

datenow=`date +"%Y%m%d"`
mysqldump --opt mythconverg > /var/lib/backups/mysqldump-${datenow}.sql
gzip -9 /var/lib/backups/mysqldump-${datenow}.sql
/usr/bin/scp /var/lib/backups/mysqldump-${datenow}.sql.gz
someotheruser at someothersystem:/usr/local/backups/mysql/