[mythtv-users] recordedmarkup table corruption

[Robert Tsai]

On Thu, Apr 28, 2005 at 07:39:47PM -0700, Chris Petersen wrote:
> Since I've posted this everywhere else (and probably here before,
> too), feel free to take a look at this:
> 
> http://forevermore.net/files/mythtv_misc/optimize_mythdb.pl.txt
> 
> It loads the mysql.txt file from your mythtv installation, connects
> to mysql, and repairs and optimizes ALL of the tables.  Add it to a
> daily cron job and you'll not only be assured of your tables being
> repaired if you're not there to watch them, but it'll keep your disk
> space optimized (the recordedmarkup and program tables are
> especially good at growing larger than the data they store).

Why not just incorporate this into the built-in myth timer stuff (a la
the internally-scheduled mythfilldatabase)?

--Rob