[mythtv-users] SQL Error: Can't open file:
'programrating.MYI'. (errno: 145)
Michael Gargiullo
gargiullo at comcast.net
Tue Mar 23 11:12:11 EST 2004
Sorry for the top post, but..
Is Mysql running?
$ps ax | grep mysql
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
More information about the mythtv-users
mailing list