[mythtv-users] is it possible to copy a myhtconverg db to a system with a different tuner

Alan Anderson andersonas at adelphia.net
Mon Dec 20 02:49:17 UTC 2004


I ran accross the answer about 20 minutes after placeing my question.

Instead if trying to import the entire DB just extract the record, 
recorded, oldrecorded and recordedmarkup records.  Then pull that in.

After you change the hostname on the backed up file to the new systems 

grep "INSERT INTO record " mysql-backup.sql > restore.sql
grep "INSERT INTO recorded " mysql-backup.sql >> restore.sql
grep "INSERT INTO oldrecorded " mysql-backup.sql >> restore.sql
grep "INSERT INTO recordedmarkup " mysql-backup.sql >> restore.sql

mysql -u root -p mythconverg
mysql> delete from record;
mysql> delete from recorded;
mysql> delete from oldrecorded;
mysql> delete from recordedmarkup;
mysql> quit

mysql -u root -p mythconverg < restore.sql

So I am about ready to try this...

More information about the mythtv-users mailing list