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
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Reply via email to