Okay,
This has already happened once and I had to restore it from backup. I
was using one of the pre-stable betas but i am not on the most current
stable release and it still crashes. The table is a little over 500MB. I
was doing a lot of inserts to the database both times this happened. T
This is probably a really stupid error, but I'm unable to run myisamchk:
[root@cssrvr1 mail2db.bad]# ls
category.MYD groupcounter.MYD list.MYD message.MYD threadrequest.MYD
category.MYI groupcounter.MYI list.MYI message.MYI threadrequest.MYI
category.frm groupcounter.frm list.frm mess
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
es 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 PR
gt;>> 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 subje
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
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 wrote:
> > Can anyone tell me how to fix this error:
> >
> > ERROR 1016: Can't ope
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 (
l
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)
http://l