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