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

[Mark]

Fantasitc answer.  That is what I will do.

Thank you very much.

Mark
  ----- Original Message ----- 
  From: George Nassas 
  To: Discussion about mythtv 
  Sent: Monday, August 07, 2006 7:01 AM
  Subject: Re: [mythtv-users] Combine two backends into one?Interesting problem


  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




------------------------------------------------------------------------------


  _______________________________________________
  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/20060807/132c2693/attachment.htm