Here is a script to backup mythconverg mysql tables weekly. Put it in /etc/cron.weekly. I use it on debian so you may have to change for others.
Paul
#!/bin/sh # mythtv-mysql-backup cron.weekly script - backup and rotate mythtv mysql tables #To restore: (assuming that you've dropped the database) # $ mysql -u root # mysql>create database mythconverg; # mysql>exit # $ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql #Deleting the MySQL database # NOTE: Performing this step will remove the entire database. You will lose all of # your settings and will need to re-run the mc.sql script to setup the database # structure before running the setup program. # $ mysql -u root # mysql> drop database mythconverg; # mysql> quit set -e set -u MYDUMP="/usr/bin/mysqldump --defaults-extra-file=/etc/mysql/debian.cnf" NAME="mythconverg" FILE="/var/backups/$NAME.sql" logger -p daemon.info -i -t$0 "Creating backup of $NAME tables." $MYDUMP $NAME -c > $FILE savelog -c 4 -q $FILE # End of file.
_______________________________________________ mythtv-users mailing list [EMAIL PROTECTED] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
