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

Michael T. Dean mtdean at thirdcontact.com
Mon Aug 6 01:49:40 UTC 2007

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.


More information about the mythtv-users mailing list