[mythtv-users] Remove program listings from database

[Michael T. Dean]

On 08/25/06 06:57, Nick wrote:

>On 25/08/06, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>  
>
>>On 08/24/2006 04:53 PM, Nick wrote:
>>
>>>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.
>>
>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
>table?
>

No.  But, when you do a mythfilldatabase, mfdb will clear data from 
program, programrating, credits, and programgenres for specific channels 
for the day whose data was just downloaded.  Normally, if mfdb sees data 
in the program table, it will only download tomorrow and +13.  By 
deleting from program, we're clearing out the data so that it downloads 
all days.  When doing so, it should clear out the other tables for us.

And, if that doesn't clean it up, mfdb eventually "expires" old data 
(more than 7 days old if you specify "--no-delete" or more than 1 day 
old if you don't) from these tables (and more).  So, the old data 
shouldn't hang around for more than about a week after the starttime.

Mike