Myisam crash table failed reapir


We have a Mysql Server 5.5 and when I have a Myisam big table (About 30 Gigabyte) using partition.

The server go down (power failure) and when I restart, the table has marked as crash.

When I try to do a repair (quick or extended), the mysql always stopped.

Any suggestion, how can I try to repair this table?

Who is Participating?
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
How have you tried to do the repair so far?

If you strictly used REPAIR TABLE, you can try myisamchk method
I recall (this was about 6 years ago) having a database that size and having to recover from crashes always seem to require myisamchk with options

Try using the --force in this case for example

Hope that helps!
lnriveraAuthor Commented:
Question has a verified solution.

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

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.