Brion L. VIBBER wrote:
I got this MySQL error message: "Got error 127
from table handler".
Well, I don't know what it means, but there it is.
Apparently (
http://www.mysqldeveloper.com/faqs/index.pcgi?id=40) this
means:
What does "Got error 127 from table handler" mean
This error literally means: Record-file is crashed
To correct this error; simply run myisamchk or REPAIR <tbl>; against
that table.
So I have run this:
# myisamchk -r /usr/local/var/wikipedia/cur
- recovering (with sort) MyISAM-table '/usr/local/var/wikipedia/cur.MYI'
Data records: 347
- Fixing index 1
- Fixing index 2
- Fixing index 3
And this seems to have not fixed anything.
I'm a little vague on how to run REPAIR <tbl>; against that table.
I mean, look at this please:
[root@ross /root]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 65 to server version: 3.23.37
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> use wiki;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'cur'
Database changed
mysql> repair cur;
ERROR 1064: You have an error in your SQL syntax near 'cur' at line 1
mysql>
So this suggests that I don't understand.
--Jimbo