Table error/repair question
So I have a particular table that keeps crashing. It gives the good ol' error message: "Table is Marked as Crashed and Should be Repaired". Besides using a query 'REPAIR TABLE xxxx' what are my options? This is happening almost daily.
Would any of the following help? (I ask before doing because of the amount of people using it at any given moment)
- Recreate the particular table from scratch?
- Change it from MyISAM to Innod?
Is there a way to detect this and repair before users see that error message (or error 134)?