[mythtv-users] merge recordings in mythtv

[Michael T. Dean]

On 01/30/2010 03:28 PM, Adam Brown wrote:
> I have both a master and a slave backend. Recently, my master backend
> went down. During that time I turned the slave into the master, and
> have recorded shows on it. Now I've got my original master working
> again. I've copied the recordings (the actual files) from my temporary
> master back to the original master. Now, how can I merge the recorded
> database information from my temporary backend to my original master
> backend?
>
> Will a mysqldump on certain tables work?
>   

Nope.

IMHO, the best solution is to take the smaller number of recordings and
stick them in MythVideo (and re-record reruns if you want to keep them
in TV).

The other option is to try to use the old, legacy, unmaintained,
use-at-your-own-risk myth.rebuilddatabase.pl or myth_find_orphans.pl
scripts (where you'll likely need to type in all the titles, subtitles,
descriptions, ...

The best approach when you lost your master backend would have been to
actually convert your slave backend into master backend on the same
mythtv database that the master backend you lost used--meaning you
backup the DB from the master (or use the newest, just-before-the-crash
backup from your normal backup runs***), restore that backup to the
slave backend, then change the slave backend to become the master
backend (and then reverse the process once you got your old master
backend up and running).

When it comes to MythTV, there can be only one database.  It's like a
Highlander thing.

***http://www.mythtv.org/wiki/Database_Backup_and_Restore

Mike