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

[Nick Morrott]

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.

Mike,

Is this method specific to missing recordings? I hadn't seen this
documented before so it's a useful tip.

Cheers,
-- 
Nick

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin