[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