[mythtv-users] many mysql errors
bjm at lvcm.com
Sat Oct 15 20:14:26 EDT 2005
Ricardo Kleemann wrote:
> 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
More information about the mythtv-users