[mythtv-users] Re: Moving shows between backends?

[Chris Pinkham]

>      I have a slave backend that used to be a master.  This slave has a
> number of recordings that I'd like to keep (as mythtv-viewable shows,
> not viewable via the video player).  However, all of the show data is in
> the old (now unused) mythtv database that is on the slave.  The (new)
> master, having no knowledge of those shows, does not know about them,
> and does not make them viewable.
> 
>      Is this possible?

Easiest way would be to just move the files off the slave into the
master's video directory.  Then using mysqldump, backup just the recorded,
and recordedmarkup tables from the slave database.  Make sure there aren't
any "create table", "drop table", or "truncate table" sql statements or
anything like those in your backup, all you want is the "insert"
statements.  Then take that backup file and just run it against your master
database.  That will restore the videos so they will show up and since
you copy recordedmarkup also, you'll restore the commercial skip info and
the GOP seek info if you're using a hardware encoding TV tuner.

-- 

Chris