[mythtv-users] Need a way to clean up database after losing recordings

[Craig Fry]

On 8/5/07, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>
> On 08/05/2007 07:59 PM, Nick Morrott wrote:
> > On 05/08/07, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> >
> >> On 08/05/2007 04:40 AM, Craig Fry wrote:
> >>
> >>> Long story short, I lost all my recordings.  I would like to do a SQL
> >>> command or script that will remove everything that Myth THINKS I still
> >>> have from the previously recorded list so it rerecords and then clean
> >>> up the table so it doesn't still think those programs are recorded.
> >>> Any suggestions?
> >>>
> >> Go to Watch Recordings in the frontend.  While in the "All Programs"
> >> group (left column), hit Menu ('m') and "Add this group to the
> >> playlist".  Then hit Info ('i'), "Playlist Options", "Delete this
> >> playlist".  (I may have confused the Menu and Info keys, so try both
> >> 'til you find which it should be.)  This approach will mark all the
> >> recording to allow re-recording.
> >>
> > Is this method specific to missing recordings? I hadn't seen this
> > documented before so it's a useful tip.
> >
>
> Nope.  It would do exactly as the OP planned--delete all recordings.
> Basically, it deletes the entire playlist and since all recordings are
> in the playlist.
>
> However, I think you were asking about whether the marking a recording
> to allow re-recording is specific to missing recordings.  In fact, it
> won't mark any to allow re-recording.  Should have said, "This method
> will not mark all the recordings to allow re-recording."  Sorry about
> the very critical missing word.
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

In the end I just sat there and did it manually.  It certainly tells me I
record to much and watch to little.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070806/a01eddab/attachment.htm