From: Ananda Kumar
Date: February 26 2010 7:57am
Subject: Re: "Incorrect key file for table '...'; try to repair it" on Innodb 
	table
List-Archive: http://lists.mysql.com/mysql/220814
Message-Id: <829b199c1002252357q4ce9111s6081daa11344502d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=00504502cd48a0366004807c3e86

--00504502cd48a0366004807c3e86
Content-Type: text/plain; charset=ISO-8859-1

This is due to less space in your /tmp file system.
Change tmpdir parameter to point to a file system having more space and then
try the adding the constraint.

regards
anandkl

On Fri, Feb 26, 2010 at 5:14 AM, Yang Zhang <yanghatespam@stripped> wrote:

> I'm getting "Incorrect key file for table 'stock'; try to repair it"
> for "alter table stock add constraint pk_stock primary key (s_w_id,
> s_i_id);". I can't do "repair table" on this since it's an innodb
> table. Googling doesn't turn up any clear answers. Any way to recover
> from this, or is mysqldump + load data the way to go?
> --
> Yang Zhang
> http://www.mit.edu/~y_z/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=anandkl@stripped
>
>

--00504502cd48a0366004807c3e86--