"Incorrect key file for table "..."; try to repair it" on Innodb

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=gcdmg-mysql-2@m.gmane.org

Re: "Incorrect key file for table "..."; try to repair it" on Innodb

--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 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@gmail.com
>
>

--00504502cd48a0366004807c3e86--