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