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 mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users