On Thu, 2006-01-26 at 16:00 -0500, [EMAIL PROTECTED] 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
[EMAIL PROTECTED]:/usr/local/backups/mysql/
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
