Okay, I ran "myisamchk -c message.MYI" and got back:
myisamchk: error: 22 when opening MyISAM-table 'message.MYI'
perror says error 22 is "Error code 22: Invalid argument"
Is there a way I can regenerate the index file? I can still open mysql
and do queries on the table so it does not appear to be fatal. Hmm.
- Dan
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/26/01, 12:11:09 PM, "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]>
wrote regarding Re: alter table error:
> On Mon, 26 Mar 2001, Daniel Adams wrote:
> > Well, I wanted to limit the size of the index so it wouldn't take up a
> > lot of space. The message table is about 500mb right now and is going to
> > get a lot bigger. Well not limiting the size of the index get rid of the
> > error?
> >
> Actually you should be able to do that, and it is quite advisable. I
assume/guess that the error code returned with your error message is
actually '126'.
> Looking it up with perror, I get:
> 126 = Index file is crashed / Wrong file format
> If this is correct, it would be nice to ran a myisamchk to check on your
indeces and then try again.
> regards,
> thalis
---------------------------------------------------------------------
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
