<br><br><div><span class="gmail_quote">On 1/11/07, <b class="gmail_sendername">Matt Rude</b> <<a href="mailto:mythtv@mattrude.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mythtv@mattrude.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
ryan patterson wrote:<br>> I assume the root cause of the error is because of slightly different<br>> versions of mythtv between old/new installs. But I'm not sure which is<br>> older and which is newer. My old setup was running knoppmyth which is a
<br>> distribution based on debian that automatically sets up mythtv. I think<br>> I was running .20-fixes It is possible that the mythtv version in the<br>> Edgy repository is actually older. This might be a deal breaker. I'll
<br>> experiment some more too see if I can get it to work.<br>><br>> On 1/11/07, *Adrian* <<a href="mailto:642040@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">642040@gmail.com
</a> <mailto:<a href="mailto:642040@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">642040@gmail.com</a>
>> wrote:<br>><br>> On 1/11/07, ryan patterson <<a href="mailto:ryan.goat@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ryan.goat@gmail.com</a><br>> <mailto:
<a href="mailto:ryan.goat@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ryan.goat@gmail.com</a>>> wrote:
<br>> > I am trying to upgrade my mythtv setup. I am moving from a<br>> debian install<br>> > to a ubuntu install.<br>><br>> I am just about to do the same, so I was reading this thread
<br>> carefully...<br>><br>> Could the problem be that you are migrating from an older version of<br>> Myth to a newer version? If that is the case, the database structure<br>> is likely different. I think that the instructions that you were
<br>> following assume that you are migrating from and to the same<br>> version...<br>><br>> Sorry, I am not sure of the best way to recover?<br>><br>> Adrian<br><br>I beleave you are trying to downgrade from a database that (at lease for
<br>a time) was running the SVN trunk or the bleeding version of mythtv. you<br> database error talks about storage groups witch is only on the trunk<br>(devilment) version at this time (not 0.20). so if your trying to<br>
install mythtv 0.20 on your new setup I would suggest you only restore<br>the tables that you need to restore and no others (but 1st backup and<br>wipe your *new* database before you try to restore)<br><br>-Matt</blockquote>
<div><br>Matt, could you tell me how to restore only some tables? I am only interested in preserving the list of already viewed shows. I can manually reenter the recording profiles and all other settings. I don't know mysql or the mythconverge database. The instructions I originally followed say to grep the following items out of the database dump:
record, recorded, oldrecorded, recordedprogram, recordedrating, & recordedmarkup. I assume that I only want some of those. but I have no idea which ones.<br clear="all"></div></div><br>-- <br>_____________<br>Ryan Patterson