[mythtv-users] Combine two backends into one? Interesting problem

[George Nassas]

On 6-Aug-06, at 3:52 PM, Brad Templeton wrote:

> It's pretty simple.

It isn't. He's crossing versions and there are schema changes. One I  
remember for sure is .18 generates the recording's filename from the  
channel + start/end times while .19 has a column for filename.  
Changing the recording host won't do it.

I suggest upgrading the .18 database to .19 and using nuvexport to  
create sql exports of all the recordings which can then be imported  
to the target system. The sequence of events would be:

1 - shutdown the .19 system
2 - move its db to a safe place
3 - copy in the .18 db
4 - bring up the .19 backend which will upgrade the .18 db to .19
5 - nuvexport all the recordings
6 - shutdown the backend and restore the original .19 db
7 - import the exported recordings (mysql < *.sql where the  
nuvexports are)
8 - enjoy a much larger recording library

I'm not sure if the .18 recording files have to be in the recordings  
directory when you do the nuvexport. Of course, they have to be there  
after you do the import. If I've glossed over any details just ask.

- George

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060807/0587d0eb/attachment.htm