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
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS" <[EMAIL PROTECTED]> wrote regarding
> Re: alter table error:
>
>
> > It's better like this:
> > alter table message add index subject2 (subject);
>
> > ----- Original Message -----
> > From: "Daniel Adams" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, March 26, 2001 7:19 PM
> > Subject: alter table error
>
>
> > Can anyone tell me what this means and how to fix it? I ran the below
> > query to simple add another index and this is what i got. Thank you.
>
> > mysql> alter table message add index subject2 (subject(10));
> > ERROR 1034: 126 for record at pos 176850808
>
> > - Dan
>
> > ---------------------------------------------------------------------
> > 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
>
>
---------------------------------------------------------------------
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
