[mythtv-users] Cleanup script

[George Nassas]

On 9-Oct-06, at 9:23 PM, Monkey Pet wrote:

> Hi, my mythbox has been running for the last 4 years and gone  
> though many things.  I was wondering if their is a script to do the  
> following: compare NUV files with entries in the db and make sure  
> it exists on both ends (files and db).  If they don't, take the  
> proper action.  I want to accomplish two things.  Free up space by  
> getting rid of rouge files.  Also cleanup the db, so I don't have  
> to manually delete a bunch of entries using the frontend.  Anyways  
> if this doesn't exist, I will just write it myself.

The contrib script myth.rebuilddatabase.pl will help you with the  
first bit - scanning for rouge files and making sure they're in the  
database. It might even locate a few rogue files as well ;)

The other half - removing db rows for entries that have no matching  
files is trickier. You can't know if a file is truly missing or if  
it's on remote storage and temporarily unavailable. On the other  
hand, it'd be nice to have a script that did consistency things like  
verifying that everything in the recordedmarkup table actually has a  
matching row in the recorded table and cleaning out the orphans. That  
would be a good addition to optimize_mythdb.pl which is looking  
pretty skimpy at the moment.

- George