I run mythfilldatabase a few times a week.<br><br>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.
<br><br>My sql dump is 139 megs. <br><div><span class="gmail_quote">On 6/11/07, <b class="gmail_sendername">Michael T. Dean</b> <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:</span><blockquote class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom: 0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
On 06/11/2007 02:40 PM, Craig Fry wrote:<br>> I'd like to clean up my mythconverg database. I've been running this<br>> thing for years upon years and it's getting huge. I'd like to clean<br>> out all the records more then a year old. Does anyone have a script
<br>> or solution? Thanks<br><br>A huge database is not due to having done too many recordings or having<br>downloaded too many listings. It's due to not running the mythtv tools<br>that perform automatic database cleanup.
<br><br>In other words, I'm guessing you're using EIT for your guide data and<br>that you never run mythfilldatabase. Running mythfilldatabase<br>"periodically" is mandatory for 0.20-fixes and below (in SVN the cleanup
<br>functionality has been moved to the backend).<br><br>So, my recommendation is to run:<br><br>mythfilldatabase --no-delete<br><br>and it will do all the appropriate cleanup for you. If your database is<br>still "huge", you need to adjust your definition of the word huge.
<br><br>My entire mysql data directory is 190MB, and the mythconverg directory<br>under it is 170MB, and I have 384 programs using 1.4TB of storage. I've<br>been running MythTV for over 3 years and have recorded 5842 programs.
<br>Of the space in use, 120MB is consumed by recordedseek (since 382 of 384<br>recordings are MPEG-2) and 28MB is consumed by romdb.<br><br>You'll likely see similar sizes (scaled for the number of MPEG-2<br>recordings you have) once you run mythfilldatabase. See
<br><a href="http://www.gossamer-threads.com/lists/mythtv/users/269833#269833">http://www.gossamer-threads.com/lists/mythtv/users/269833#269833</a> (and<br>the rest of the thread) for more info.<br><br>Mike<br>_______________________________________________
<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
</a><br></blockquote></div><br>