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

Malcolm mythtv at lds.dyndns.org
Tue Mar 23 11:28:57 EST 2004


----- 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


> On Tue, 2004-03-23 at 10:39, Malcolm wrote:
> > This morning just out of the blue I get this error when I try and hit my
> > Myth box from MythWeb
> >
> > Fatal Error at /var/www/html/mythtv/includes/programs.php, line 189:
> > SQL Error: Can't open file: 'programrating.MYI'. (errno: 145)
> > The system administrator has been notified and the problem will be
remedied
> > shortly.
> >
> > So I tried this:
> > mysql -u mythtv -p mythconverge
> > mysql> select * from programrating;
> > ERROR 1016: Can't open file: 'programrating.MYI'. (errno: 145)
> >
> > [root at mythtv mythconverg]# ls -l
/var/lib/mysql/mythconverg/programrating.*
> > -rw-rw----    1 mysql    mysql        8648 Feb 19 22:53
> > /var/lib/mysql/mythconverg/programrating.frm
> > -rw-rw----    1 mysql    mysql      269100 Mar 23 04:40
> > /var/lib/mysql/mythconverg/programrating.MYD
> > -rw-rw----    1 mysql    mysql      515072 Mar 23 04:40
> > /var/lib/mysql/mythconverg/programrating.MYI
> >
> > I have a feeling what I need to do is drop the programrating table.  Can
> > myth rebuild this table?  Perhaps if I run mythfilldatabase?  What are
my
> > options?
> >
> > Thanks
> > Malcolm
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>


----------------------------------------------------------------------------
----


_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



More information about the mythtv-users mailing list