Database Error: Table is marked as crashed and should be repaired

Hi,
I am getting this error.

Database ERROR:Database ERROR:Table './snort/event' is marked as crashed and should be repaired

I know nothing about mysql. Any suggestions?

Thanks.

NYGiantsFan

Asked: 2013-01-08

Advertise Here

1 Solution

LVL 143

Guy Hengel [angelIII / a3]Billing EngineerCommented: 2013-01-08

please try the REPAIR TABLE statement for this table:
http://dev.mysql.com/doc/refman/5.1/en/repair-table.html

LVL 2

brijesh_chauhanMySQL DBACommented: 2013-01-11

Hi,

It seems that ur table is either corrupted or crashed.

You should try the following syntax to repair that table.

repair table table_name;

it may take some time based on the data inside it.

once it done it should display the following box.

+-----------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------+--------+----------+----------+
| test.user_ident | repair | status | OK |
+-----------------+--------+----------+----------+

Thanks,

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Database Error: Table is marked as crashed and should be repaired

Join & Write a Comment Already a member? Login.

Featured Post