[mythtv-users] Migrating two MythTV systems into one?

[Michael T. Dean]

On 06/20/2006 08:37 PM, Steve Hodge wrote:

>On 6/21/06, Cecil Watson <cwatson at linkline.com> wrote:
>  
>
>>Have you read the MythTV docs?  This is covered...
>>http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
>>    
>>
>
>That's doesn't say whether combining two databases into one will cause
>any problems though.
>

It doesn't.  It won't.

However, you will need to change the value of the hostname field for the 
recording from the system whose hostname differs from the new system's 
hostname (the HOWTO assumes your new Myth box will have the same 
hostname as the old Myth box).

So, if the hostnames for your two Myth boxes are office.officedomain and 
home.homedomain and you're moving the recordings from both to a new Myth 
box called home.homedomain, you'll need to change the hostname field on 
all recordings to home.homedomain.

UPDATE recorded SET hostname = 'home.homedomain' WHERE hostname = 
'office.officedomain';

should work (but make sure you back up /all/ your databases first).

Mike