[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