[mythtv-users] mythlog.MYI error - how to fix?

[Kevin Kuphal]

Bryan Halter wrote:

> casey dunn wrote:
>
>> Help, I'd love to get this out of my logs.
>>
>> DB Error (DelLogEntry#1):
>> Query was:
>> SELECT logid FROM mythlog WHERE module= 'mythbackend' ORDER BY 
>> logdate ASC ;
>> Driver error was [2/1016]:
>> QMYSQL3: Unable to execute query
>> Database error was:
>> Can't open file: 'mythlog.MYI' (errno: 145)
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>   
>
>
> There's a mysql* utility to fix your tables for you.  I'm not at my 
> server now so I can't tell you which one but I believe its something 
> like mysqlverify.

mysqlcheck

You can refer to the documentation on the MySQL website for proper usage

Kevin

-- 
Looking for affordable webhosting?  http://www.sitecity.net