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:[EMAIL PROTECTED]] >>Sent: Tuesday, September 17, 2002 9:00 AM >>To: [EMAIL PROTECTED] >>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 >> >> >> >> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
