[mythtv-users] Cleaning up old records

[Michael T. Dean]

On 06/11/2007 02:40 PM, Craig Fry wrote:
> I'd like to clean up my mythconverg database.  I've been running this
> thing for years upon years and it's getting huge.  I'd like to clean
> out all the records more then a year old.  Does anyone have a script
> or solution?  Thanks 

A huge database is not due to having done too many recordings or having
downloaded too many listings.  It's due to not running the mythtv tools
that perform automatic database cleanup.

In other words, I'm guessing you're using EIT for your guide data and
that you never run mythfilldatabase.  Running mythfilldatabase
"periodically" is mandatory for 0.20-fixes and below (in SVN the cleanup
functionality has been moved to the backend).

So, my recommendation is to run:

mythfilldatabase --no-delete

and it will do all the appropriate cleanup for you.  If your database is
still "huge", you need to adjust your definition of the word huge.

My entire mysql data directory is 190MB, and the mythconverg directory
under it is 170MB, and I have 384 programs using 1.4TB of storage.  I've
been running MythTV for over 3 years and have recorded 5842 programs. 
Of the space in use, 120MB is consumed by recordedseek (since 382 of 384
recordings are MPEG-2) and 28MB is consumed by romdb.

You'll likely see similar sizes (scaled for the number of MPEG-2
recordings you have) once you run mythfilldatabase.  See
http://www.gossamer-threads.com/lists/mythtv/users/269833#269833 (and
the rest of the thread) for more info.

Mike