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=arch...@jab.org
