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

[Michael Gargiullo]

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
> 
> 
> > Sorry for the top post, but..
> >
> > Is Mysql running?
> >
> > $ps ax | grep mysql
> 
> Absolutely.  Notice the part where I did this:
> > > mysql -u mythtv -p mythconverge
> > > mysql> select * from programrating;
> > > ERROR 1016: Can't open file: 'programrating.MYI'. (errno: 145)
> 
> But to answer your question yes I did a "ps -ef|grep mysql" and it's up :)
> 
> Thanks
> Malcolm
<snip>

Right...sorry  still on first cup of coffee...
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;