Geek Answers Handbook

How do you recover from the "wrong key file" using MySQL (InnoDB)?

Incorrect key file for table 'widgets'; try to repair it

This is the error message that MySQL gives me when trying to apply a new index to an existing (very large) table. Of course, when I follow the error message trying to fix it:

mysql> repair table widgets;
+-------------------+--------+----------+---------------------------------------------------------+
| Table             | Op     | Msg_type | Msg_text                                                |
+-------------------+--------+----------+---------------------------------------------------------+
| tedsdb.widgets    | repair | note     | The storage engine for the table doesn't support repair | 
+-------------------+--------+----------+---------------------------------------------------------+
1 row in set (0.00 sec)

What is my best course of action here (after an obvious full backup before messing around)?

UPDATE: I created a new table (MyISAM) of the same schema, copied all the records (paste into select), changed the engine in the new table (InnoDB), renamed the damaged table and renamed the new table, then tried again and got the same error.

+5
source share
3

, . MySQL , /tmp .

+11

, .

ALTER TABLE widgets;
0

Alter innodb, "tmpdir" . 1034: - "tmpdir" , alter .

, Alter, "tmpdir" . tmp 100%, :).

0

More articles:


All Articles