开发者

Can't access mysql table, get a message that it has crashed

开发者 https://www.devze.com 2023-01-08 06:28 出处:网络
I have a a mysql table that I can\'t access, I get the following error ERROR 1194 (HY000): Table \'menu_config\' is m开发者_运维问答arked as crashed and should be repaired

I have a a mysql table that I can't access, I get the following error

ERROR 1194 (HY000): Table 'menu_config' is m开发者_运维问答arked as crashed and should be repaired

How do I go about in fixing this? And will all my data be lost?


Try the following SQL statement:

REPAIR TABLE 'menu_config'


O E is correct, REPAIR TABLE 'menu_config' should do it. If you don't have direct access to the server via a console, phpMyAdmin also has a "repair table" option which should do the trick.

0

精彩评论

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