[mythtv-users] Merging two master backends

[Niels Dybdahl]

Hi Tapani,

You can export the recordings from one and import them into the other.

MythArchive might be used, but it is slow and the user interface is awful
when handling more than one recording.

If nuvexport script still exists (I have not used it for a long time), then
it has a very nice feature of exporting/importing a small sql script and the
recording file for each recording, but it might still be cumbersome to use
when you need to export your whole backend.

However as you need to transfer the whole contents, it is probably easier
just to make a sql dump of the recorded table and read it into the other
backend. Afterwards you will probably need to rebuild the seektable (there
is information somewhere on how to do that). I do not think that you need to
handle more than those two tables and then of course copy the recording
files.

Niels Dybdahl


On Fri, Oct 1, 2010 at 9:38 AM, Tapani Tarvainen
<mythtv at tapanitarvainen.fi>wrote:

> All,
>
> Is there any supported or known-to-work method of combining two
> previously independent master backends into one?
> Actually all I need is to be able to move recorded programs from one
> into another (recording rules are not needed but wouldn't hurt).
>
> In particular, will partial database restore work in this case
> (given that machine names &c differ) either just like that
> or with a reasonable amount of extra processing of the dump,
> or should I forget it and write custom script to copy
> necessary pieces of the database?
> In the latter case, is there documentation somewhere what needs
> to be copied or do I need to dig that out myself?
>
> --
> Tapani Tarvainen
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20101001/1dfc4da7/attachment.htm>