Have you ever been messing around with your MythTV rig and gotten an error similar to this:
" Table './mythconverg/TABLENAME' marked as crashed and needs to be repaired "
Often, this is an easy fix. If you don't already have it on your system, download the MythTV source tarball and uncompress it. Within the newly uncompressed files is a mythtv/contrib directory. Inside the contrib directory are several scripts (mostly Perl) many of which turn out to be very useful when running a MythTV system.
The optimize_mythdb.pl is the particular script we use to repair the mysql mythconverge tables. This script attempts to optimize the mythconverg mysql database, also repairing any crashed tables in the process. Run the optimize_mythdb.pl just as it is. With a normal MythTV install, the script does not require any user input. No promises here, but I've used this script to repair crashed mythconverg tables on several occasions and thus far it has always worked.
That covers the repair process, but the optimize_mythdb.pl script's primary use is optimization, not repair. It's actually recommended to run this MythTV optimization script once per a day via cron job. I haven't heard this MythTV tip mentioned too often on the mailing lists, but it's a good one to know. When you look at the optimize_mythdb.pl take the time to check out the other scripts in the /mythtv/contrib directory. Many of these scripts are useful to MythTV users (why else would they be supplied with mythtv) and warrant further inspection.