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

Alan Anderson andersonas at adelphia.net
Sun Dec 19 17:48:45 UTC 2004


I know this has been covered before but I am not understanding something.

I am in the process of moving from a mythtv v0.16 on FC1 with a pvr250mce, 
into a new FC2 mythtv v0.16 with a PCHD2000 and then I plan on moving the 
pvr-250mce into the new system.

I currently have the new system running with only the pchd2000 card.

I was hoping to dump the database on the old system before I turn it off. 
Then merge the /video disk into the new system's /video with lvm.  And copy 
over the old data base.  But I cannot get the old database onto the new 
system.  I have tried the following which I thought would work  But I am 
not a dba so I am missing something.

old system host name pvr.home.lan
new system host name video.home.lan

old system:

service mythbackend stop
mysqldump -u root -p mythconverg -c > mysql-pvr-backup.sql

ftp the file mysql-pvr-backup.sql to video

on the new system:
change the hostname in the mysql-pvr-backup.sql file.

cp mysql-pvr-backup.sql mysql-video-restore.sql
Use an editor (kwrite) to globally replace pvr.home.lan with video.home.lan 
in the mysql-video-restore.sql file.

stop the backend
service mythbackend stop

Drop the current database.
mysql -u root -p -e 'drop database mythconverg'

Create a new empty mythconverg database.
mysql -u root -p -e 'create database mythconverg'

restore the database.
mysql -u root -p mythconverg <  mysql-video-restore.sql
ERROR 1062 at line 502: Duplicate entry 'Music-FFWD-video.home.lan' for key 1

start the backend
service mythbackend start

The backend fails to start with he following error:

Told to create a NEW database schema, but the database already
has 22 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

mythtvsetup also fails to run with the same error.

I am able to dump the new system database with mysqldump and drop its 
mythconverg database and create a new mythconverg and import the database 
back in successfully.

Can you restore a database with one type of tuner (250-mce) onto a system 
with a different tuner (pchd2000)?  I thought I could do this then use 
mythtvsetup to configure the 250mce into the new system.

Maybe I need to have the 250mce installed first.  But I am just trying a 
practice run for now.  I believe I have the lvm merging process debugged.

Alan Anderson
andersonas at adelphia.net
Linux is user friendly.
Its just real picky about who its friends are.

More information about the mythtv-users mailing list