[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
Hi,
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.
thanks
--
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