?
Solved

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

Posted on 2013-01-08
2
Medium Priority
?
398 Views
Last Modified: 2013-01-21
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.
0
Comment
Question by:NYGiantsFan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38754975
please try the REPAIR TABLE statement for this table:
http://dev.mysql.com/doc/refman/5.1/en/repair-table.html
0
 
LVL 2

Accepted Solution

by:
brijesh_chauhan earned 2000 total points
ID: 38766610
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,
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Cyber News Rundown brings you the latest happenings in cyber news weekly. Who am I? I’m Connor Madsen, a Webroot Threat Research Analyst, and a guy with a passion for all things security. Any more questions? Just ask.
A look at what happened in the Verizon cloud breach.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question