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
ANNIS" [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: alte
I have an index file that has an error in it and so I can't add a new
index and i can't seem to run myisamchk on it for some reason. In there
a way that i can have it recreate the index file thus getting rid of the
errors?
- Dan
Can anyone tell me how to fix this error:
ERROR 1016: Can't open file: 'message.MYD'. (errno: 126)
Please help!!!
- Dan Adams
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Can someone please tell me what the problem is below. All I am trying to
do is pipe a backup created with mysqldump into mysql and it gives me
this error:
ERROR 1071 at line 1291: Specified key was too long. Max key length is
500
Here is the query where the error is:
CREATE TABLE list (
the error you are getting means:
126 = Index file is crashed / Wrong file format
Would be nice to run a myisamchk on the table (check manual), and of
course check that message.MYD exists under the corresponding database's
directory.
regards,
thalis
On Fri, 23 Mar 2001, Daniel Adams wro