[mythtv-users] many mysql errors

[Ricardo Kleemann]

Hi,

I've been getting a lot of mysql errors, I'm guessing the database must be 
corrupted...

How can I recreate the mysql database? From the errors I see, the "program" 
table, at a minimum, is corrupted.

In mythbackend I see errors:

DB Error (UpdateMatches):
Query was:
DELETE FROM program WHERE manualid = -1 OR  (manualid <> 0 AND -1 = -1)
Driver error was [2/1016]:
QMYSQL3: Unable to execute query
Database error was:
Can't open file: 'program.MYI' (errno: 145)

How can I recreate the necessary tables?

Ricardo