[mythtv-users] SQL Error: Can't open file: 'programrating.MYI'.
(errno: 145)
Malcolm
mythtv at lds.dyndns.org
Tue Mar 23 10:39:59 EST 2004
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
More information about the mythtv-users
mailing list