Adding index failed.. now can't view or edit table
I was adding an index on a column and the server timed out. Now all other tables in th开发者_JAVA百科e database work fine, but I am unable to access the table I was adding an index on. It does not allow me to delete its contents or the table. It just hangs while running the queries and nothing happens.
Any ideas on a possible solution?
MySQL 5.1
Try the REPAIR TABLE
command. Details at http://dev.mysql.com/doc/refman/5.1/en/repair-table.html
精彩评论