[mythtv-users] Is there any reason I shouldn't .....
Michael T. Dean
mtdean at thirdcontact.com
Wed Jan 3 18:19:35 UTC 2007
On 12/31/2006 05:55 AM, Dave Ansell wrote:
> I dont really like messing inside the database, but I want to get rid of
> all the old "one-off" recordings which clutter up the "Recording Schedules"
> screen under MythWeb.
> There seems to be no point in keeping "once" type recording schedules
> that relate to past shows.
> So is it safe to execute the following SQL occasionally as a cron job?
> delete from record where type=1 and enddate<now();
> delete from record where type=6 and enddate<now();
Short answer, "No."
Better answer: mythfilldatabase will clean these rules up properly for
you. Therefore--even if you're using only "EIT only" or "No grabber"
sources--you must run mfdb once "in a while" (you determine the
appropriate meaning of "while" in your case). So, set your cron job to
However, in SVN trunk, the mythfilldatabase cleanup tasks have been
moved to the backend, so in 0.21, this will no longer be necessary for
No-grabber and/or EIT-only users.
More information about the mythtv-users