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

[Michael T. Dean]

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