<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=iso-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Johnny wrote:
<blockquote
cite="mid:a6ecfbaa0910202120w1857f0d1qb2e98690b913028b@mail.gmail.com"
type="cite">
<blockquote type="cite">
<pre wrap="">delete from recorded;
update oldrecorded set duplicate=0 where recstatus= -3;
My hope is that doing that will cause myth to forget that it has recorded
everything I just lost recordings for, and my existing recording rules will
then cause it to re-record most of what I lost. Am I missing anything or
about to royally screw up my database?
</pre>
</blockquote>
<pre wrap=""><!---->
I don't think you need to mess with your database directly. You can
just delete the affected recordings with the "delete and allow
rerecord". I had the same problem a while back. There were some issues
to do it with a whole bunch of recordings using a playlist, but it
worked well. Read through this thread to see how I worked it out and
for suggestions that others gave:
<a class="moz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/mythtv/users/374203">http://www.gossamer-threads.com/lists/mythtv/users/374203</a>.</pre>
</blockquote>
Thanks for the suggestions! I was rather hoping to avoid manually
deleting the files since there are 321 recorded programs in the
database, which would take a long time to go through via the regular
UI. I'm not very familiar with the playlist functionality, do you
recall roughly what you had to do to make that work?<br>
<br>
Thanks,<br>
Curtis<br>
</body>
</html>