[mythtv-users] Cleaning up old records

Craig Fry craigfry at gmail.com
Mon Jun 11 22:35:08 UTC 2007


I run mythfilldatabase a few times a week.

I have records from old recordings all the way back to 2004-04-17.  I want
to remove all the old data.  I can handle seeing the same episode yearly.  I
can't even remember what I watched yesterday, let alone 2004.

My sql dump is 139 megs.
On 6/11/07, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>
> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070611/a8795a73/attachment.htm 


More information about the mythtv-users mailing list