Mysql table Crashed during Optimize, table repair taking too long
- by hellohellosharp
One of my vital tables was being optimzied and MySQL crashed in the middle of it. It then said the table was corrupt. I am running repair but it is taking over an hour, I need this table up ASAP (I will even truncate it if necessary).
Please help me get this solved. The table has about 54 million rows. This is a MyISAM.
Any additional information…