<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY
style="WORD-WRAP: break-word; khtml-nbsp-mode: space; khtml-line-break: after-white-space"
bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Fantasitc answer. That is what I will
do.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thank you very much.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Mark</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=gnassas@mac.com href="mailto:gnassas@mac.com">George Nassas</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=mythtv-users@mythtv.org
href="mailto:mythtv-users@mythtv.org">Discussion about mythtv</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, August 07, 2006 7:01
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [mythtv-users] Combine two
backends into one?Interesting problem</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>On 6-Aug-06, at 3:52 PM, Brad Templeton wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<P style="MARGIN: 0px"><FONT style="FONT: 12px Helvetica" face=Helvetica
size=3>It's pretty simple.<SPAN
class=Apple-converted-space> </SPAN></FONT></P></BLOCKQUOTE></DIV><BR>
<DIV>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.</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>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:</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>1 - shutdown the .19 system</DIV>
<DIV>2 - move its db to a safe place</DIV>
<DIV>3 - copy in the .18 db</DIV>
<DIV>4 - bring up the .19 backend which will upgrade the .18 db to .19</DIV>
<DIV>5 - nuvexport all the recordings</DIV>
<DIV>6 - shutdown the backend and restore the original .19 db</DIV>
<DIV>7 - import the exported recordings (mysql < *.sql where the nuvexports
are)</DIV>
<DIV>8 - enjoy a much larger recording library</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>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.</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>- George</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>mythtv-users mailing
list<BR>mythtv-users@mythtv.org<BR>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<BR></BLOCKQUOTE></BODY></HTML>