[mythtv-users] help needed: mythfilldatabase does not fill database (mysql error 130)

[Bruce Markey]

Asciimonster wrote:
> Bruce Markey wrote:
> 
>> Asciimonster wrote:
>>
>>> Since a crash I've experienced problems with the mysqldatabase.
>>>
>>> Every time I run mythfilldatabase it says for every entry:
>>> Unable to execute query,
>>> Cannot open 'program.MYI' (error 130)
>>
>>
>>
>> mysqlcheck -r -u mythtv -pmythtv mythconverg
> 
> 
> Sorry, that didn't work... All other tables check out ok, except program 
> where it gives the above mentioned error message.

Well, that's the point. The "-r" is for "repair". It should
print error messages when it got to the damaged file when it
was *repairing* it. Running it a second time should show no
errors if it was fixed the first time. See www.mysql.ord for
more info.

--  bjm