List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:February 26 2010 7:57am
Subject:Re: "Incorrect key file for table '...'; try to repair it" on Innodb
table
View as plain text  
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=1
>
>

Thread
"Incorrect key file for table '...'; try to repair it" on Innodb tableYang Zhang26 Feb
  • Re: "Incorrect key file for table '...'; try to repair it" on Innodb tableAnanda Kumar26 Feb