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

[Michael T. Dean]

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)
>
> I tried repairing the mysql database, like so: mysql prompt> repair 
> table program;
> Tried re-running tv_grab_nl --configure
> Tried fsck.reiserfs --rebuild-tree /dev/hdd1
>
> Nothing worked. Please help.

Have you tried mysqlcheck?
mysqlcheck -v -umythtv -pmythtv mythconverg