Got home tonight and mythtv machine was locked up solid. Rebooted it and noticed
I had no program data. Tried deleting the data in the program guide and
refilling it to no avail. Then I noticed this at the end of running
mythfilldatabase:
Crashed table. Yuck!
Tried fixing that one with the command
mysqlcheck --auto-repair --check -u mythtv -pmysqlpass
To which I got back
Then I ran mythfilldatabase again and went to my mythtv webpage to look for
program data.
It told me another table had crashed and needed to be repaired. So I figured
other tables must have crashed as well so I just wanted to find a blanket command
to check and fix all the tables with problems. I put this one together from the
--help page and it did the trick. Everything is back up and working. The following command
that did it was
mysqlcheck --auto-repair -A -u mythtv -pmysqlpass
It finds all corrupted tables and fixes them if possible. Output from command is
below. Output from this command is below. The "..." is space where lot's of other tables
were.