Re: Unable to add index

2002-09-17 Thread Gerald Clark
;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, Septemb

RE: Unable to add index

2002-09-17 Thread Mike Lucente
le 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 a

RE: Unable to add index

2002-09-17 Thread Victor Pendleton
: 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 

Unable to add index

2002-09-17 Thread Mike Lucente
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 ' on the table in question. What should I try next? Version: Server version 3.23.29a-gam