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 [EMAIL PROTECTED] Linux is user friendly. Its just real picky about who its friends are.
_______________________________________________ mythtv-users mailing list [EMAIL PROTECTED] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
