Nov 202011
 

http://www.mythtv.org/wiki/Database_Backup_and_Restore

One of my first experiences with mythtv was restoring a recording and a dump of the MySQL database before I could buy my own tuner card. It was cool to see recordings populated and get a feel for the UI, but it was ultimately pretty pointless. Anyhoo, I bork’d my mythbuntu setup and needed to migrate my previous recordings to another installation. Come to find out, this has gotten so much simpler than ever before!

cd /home/raging
wget https://github.com/MythTV/mythtv/raw/master/mythtv/programs/scripts/database/mythconverg_backup.pl
wget https://github.com/MythTV/mythtv/raw/master/mythtv/programs/scripts/database/mythconverg_restore.pl
chmod a+x mythconverg_backup.pl mythconverg_restore.pl
echo "DBBackupDirectory=/home/raging" > ~/.mythtv/backuprc
perl /home/raging/mythconverg_backup.pl

Advertisement:

I’m going to assume you know how to copy all the files from /var/lib/mythtv/recordings/ to another location and back
I’m also going to assume you know how to copy the backup file created from your home directory to another location and back


cd /home/raging
wget https://github.com/MythTV/mythtv/raw/master/mythtv/programs/scripts/database/mythconverg_backup.pl
wget https://github.com/MythTV/mythtv/raw/master/mythtv/programs/scripts/database/mythconverg_restore.pl
chmod a+x mythconverg_backup.pl mythconverg_restore.pl
perl mythconverg_restore.pl --drop_database --create_database --directory /home/raging --filename mythconverg-1264-20111120212038.sql.gz

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)