[mythtv-users] recordedmarkup table corruption

Chris Petersen lists at forevermore.net
Fri Apr 29 02:39:47 UTC 2005


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).

-Chris


More information about the mythtv-users mailing list