[mythtv-users] SQL Error: Can't open file:'programrating.MYI'.(errno: 145)

Malcolm mythtv at lds.dyndns.org
Tue Mar 23 13:50:04 EST 2004


----- Original Message ----- 
From: "Michael Gargiullo" <gargiullo at comcast.net>
Sent: Tuesday, March 23, 2004 11:01 AM


> On Tue, 2004-03-23 at 11:28, Malcolm wrote:
> > ----- Original Message ----- 
> > From: "Michael Gargiullo" <gargiullo at comcast.net>
> > Sent: Tuesday, March 23, 2004 10:12 AM

> > > > mysql -u mythtv -p mythconverge
> > > > mysql> select * from programrating;
> > > > ERROR 1016: Can't open file: 'programrating.MYI'. (errno: 145)
>
> Assuming permissions haven't changed on the DB file, and it's still
> owned by mysql user.
>
> error 145 also means data corruption, you can try to fix it like so:
>
> mysql> REPAIR TABLE programrating;

That seems to have done the trick.  Thanks a lot for your help.  I wonder
how a table just gets corrupted like that?

Malcolm



More information about the mythtv-users mailing list