<div dir="ltr">Jim,<br><br>Thanks for the link. I don't know how I missed the HOWTO page about this or the wiki in my googling, but I appreciate you (and the others) providing me with documentation.<br><br>What kind of duplicate entries would show up? Do you mean your list of programs to be recorded know had the test runs you setup AND the data from your previous install? Were there other duplicates that I should watch out for?<br>
<br>Ryan<br><br><div class="gmail_quote">On Mon, Sep 1, 2008 at 3:24 PM, James Skimming <span dir="ltr"><<a href="mailto:James.Skimming@portraitsoftware.com">James.Skimming@portraitsoftware.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-GB">
<div>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Also </span><span style="font-size: 10pt; color: rgb(31, 73, 125);">Ryan</span><span style="font-size: 10pt; color: rgb(31, 73, 125);">,</span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">I originally had a problem with duplicate entries, because I'd
recorded some test programs after creating the new system. I was able to delete
all previous data through the frontend, and then the import worked fine.</span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Jim.</span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US"> <a href="mailto:mythtv-users-bounces@mythtv.org" target="_blank">mythtv-users-bounces@mythtv.org</a>
[mailto:<a href="mailto:mythtv-users-bounces@mythtv.org" target="_blank">mythtv-users-bounces@mythtv.org</a>] <b>On Behalf Of </b>James Skimming<br>
<b>Sent:</b> 01 September 2008 14:20<br>
<b>To:</b> Discussion about mythtv<br>
<b>Subject:</b> Re: [mythtv-users] Import Old Previously Recorded database
table?</span></p>
</div>
</div><div><div></div><div class="Wj3C7c">
<p> </p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Hi Ryan,</span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">I've just done the same for all the recording data.</span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">The instructions here show you how to do it.</span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"><a href="http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7" target="_blank">http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7</a></span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Regards,</span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Jim.</span></p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US"> <a href="mailto:mythtv-users-bounces@mythtv.org" target="_blank">mythtv-users-bounces@mythtv.org</a>
[mailto:<a href="mailto:mythtv-users-bounces@mythtv.org" target="_blank">mythtv-users-bounces@mythtv.org</a>] <b>On Behalf Of </b>Ryan Wilson<br>
<b>Sent:</b> 01 September 2008 14:14<br>
<b>To:</b> <a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<b>Subject:</b> [mythtv-users] Import Old Previously Recorded database table?</span></p>
</div>
<p> </p>
<div>
<p style="margin-bottom: 12pt;">I had an 0.20.2 mythtv install that
worked great for me. But I had to stop using that computer and I was able to
dump the MySQL database before I lost access to that machine. Now I've got a
0.21 mythtv install on a new computer that's working great. I don't mind to
reinput the recording schedule for my favorite TV shows, but I hate that the
new install doesn't know about all the episodes I watched on the previous Myth
box.<br>
<br>
So, my question is, with the database dump from my 0.20.2 box, can I just
import the oldrecorded table into my 0.21 database and have it "know"
about all the shows I've already seen? Or is more complicated than that? I'm
familiar with mysql and SQL and don't mind messing around with them if there is
no easier way to restore this data. The tables look the same so I think I'll
just try it out and see what happens, but I'd like to see if anyone else had
any experience with this or know if the contents of the table depended on
anything else that I should also import.<br>
<br>
Ryan</p>
</div>
<p>DISCLAIMER: This e-mail is intended only for the addressee
named above. As this e-mail may contain confidential or privileged information,
if you are not the named addressee, you are not authorised to retain, read,
copy or disseminate this message or any part of it. If you received this email
in error, please notify the sender and delete the message from your computer. </p>
</div></div></div><div><div></div><div class="Wj3C7c">
DISCLAIMER: This e-mail is intended only for the addressee named above. As this e-mail may contain confidential or privileged information, if you are not the named addressee, you are not authorised to retain, read, copy or disseminate this message or any part of it. If you received this email in error, please notify the sender and delete the message from your computer.
</div></div></div>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br></div>