[mythtv-users] Remove program listings from database

[Michael T. Dean]

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;

or

TRUNCATE TABLE program;

should be good enough.

Mike