[mythtv-users] Mass delete and mass forget old recordings

[Edward Rudd]

On Tue, 2004-09-14 at 14:32, John Gruenenfelder wrote:
> I have recorded quite a number of shows which I now wish to delete.  I plan to
> re-record them and transcode them external to Myth (perhaps with some very
> time consuming 2 pass method).  Currently, many of the recorded shows have
> been transcoded by Myth directly, but because of NUV container issues
> discussed elsewhere, it's hard to play back with other software.

There is a driver that can be installed in windows to allow access to
the nuv files to windows media player (or any other app that uses direct
show).
http://dsmyth.sourceforge.net/
I've found this works quite well in playing videos on a windows box
(well except for my dad's messed up win98 system)

And I personally just use mplayer to play the files on my linux box
(which has the nuv patch added and is from atrpms.net)

> Obviously, I can select each one separately, but this will take a long long
> time.
Yup, a New feature needs to be added to "delete entire group". or a fix
to the mythweb frontend to go back to the "show" after deleting instead
of going to the entire list of shows. 
> 
> I fully suspect the answer is some database operations, but I know little
> enough SQL that a fairly specific answer (i.e. "Use this query:") would be
> most helpful.  Thanks!

I tend to use phpMyAdmin to play with the database.. it should easy the
creation of SQL. but playing with the DB directly is "at your own risk".
it required deleting records from the recorded and oldrecorded tables

-- 
Edward Rudd <eddie at omegaware.com>
Website http://www.outoforder.cc/