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.
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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1