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

Question

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

ERROR 1194 (HY000): Table 'menu_config' is marked as crashed and should be repaired

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

Answer 1

Try the following SQL statement:

REPAIR TABLE 'menu_config'

Answer 2

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.