[mythtv-users] many mysql errors

[Bruce Markey]

Ricardo Kleemann wrote:
> Hi,
> 
> I've been getting a lot of mysql errors, I'm guessing the database must 
> be corrupted...

Support for that software is hosted at www.mysql.org .

> 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?

mysqlcheck -r -u mythtv -pmythtv mythconverg

--  bjm