开发者

Adding index failed.. now can't view or edit table

开发者 https://www.devze.com 2023-02-13 01:42 出处:网络
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 all

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

精彩评论

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