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

[Bruce McKenzie]

MySQL can be "moved" by moving the database files (usually in 
/var/lib/mysql). They're just regular files. Be sure to stop mysqld first.

(This is a general case, and may require tweaking for myth: stopping fe/be, 
updating mysql after it is brought up but before myth is brought up...)

B.

At 09:48 AM 12/19/2004, you wrote:

>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.
>
>
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

---
Bruce J. McKenzie    |   bruce at doublepup.com    |   DoublePup Enterprises, Inc.
http://www.doublepup.com    |    Consulting Services for Systems Development