Myisam crash table failed reapir

Hi,

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?

thanks
lnriveraAsked:
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 http://dev.mysql.com/doc/refman/5.5/en/repair-table.html
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 http://dev.mysql.com/doc/refman/5.5/en/myisamchk-repair-options.html

Try using the --force in this case for example

Hope that helps!
0
 
lnriveraAuthor Commented:
Great!
0
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.