Don't run myisamchk while the server is running.
Mike Lucente wrote:
>Isn't that what 'myisamchk -o' does?
>
>On Tue, 17 Sep 2002, Victor Pendleton wrote:
>
>>Mike,
>> Erro 127 means that the table is marked as crashed. You should run a
>>check and repair if necessary.
>> Error code 127: Unknown error
>> 127 = Record-file is crashed
>>
>>I hope this helps.
>>
>>
>>
>>-----Original Message-----
>>From: Mike Lucente [mailto:ml@stripped]
>>Sent: Tuesday, September 17, 2002 9:00 AM
>>To: mysql@stripped
>>Subject: Unable to add index
>>
>>
>>Hello,
>>
>>I cannot add an index to one of my tables. I get the following message:
>>
>>mysql> alter table devlog add index (dt_status);
>>ERROR 1030: Got error 127 from table handler
>>
>>I've run 'myisamchk -o <table>' on the table in question.
>>
>>What should I try next?
>>
>>Version: Server version 3.23.29a-gamma
>>OS: RedHat Linux 7.2
>>
>>
>>
>>
