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 > > --------------------------------------------------------------------- > 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 > -- Mike Lucente CTO [EMAIL PROTECTED] 561-218-5527 --------------------------------------------------------------------- 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