开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜