[mythtv-users] is it possible to copy a myhtconverg db to
a system with a different tuner
bruce at doublepup.com
Sun Dec 19 18:14:03 UTC 2004
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...)
At 09:48 AM 12/19/2004, you wrote:
>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
>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.
>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
Bruce J. McKenzie | bruce at doublepup.com | DoublePup Enterprises, Inc.
http://www.doublepup.com | Consulting Services for Systems Development
More information about the mythtv-users