[mythtv-users] Remove program listings from database
knowledgejunkie at gmail.com
Fri Aug 25 10:57:55 UTC 2006
On 25/08/06, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> On 08/24/2006 04:53 PM, Nick wrote:
> >On 24/08/06, OJ <ole at legaard.net> wrote:
> >>I'm running 0.19.
> >>Is it possible to delete all program listings from the database?
> >If you want to keep your video sources but delete all program listing
> >information, the only way to achieve this is to edit the database
> >directly - remember this is more risky, and you really need to remove
> >the information from all the associated program listing tables
> >(program, credits, programrating, programgenres, etc).
> You can skip this and they'll eventually get "expired".
> DELETE FROM program;
> TRUNCATE TABLE program;
> should be good enough.
Just so I understand this - if you delete just the contents of the
program table, does MFDB automatically determine the newly orphaned
information in the associated credits/rating/genre tables and delete
it as soon as it can't find the keyed information in the program
MythTV Official wiki:
MythTV users list archive:
More information about the mythtv-users