Fix crashed tables in mysql
Saturday, August 7, 2010 11:59:00 PM
##. How to repair table
1. backup database
2. under mysql prompt
check table the_crashed_table (to see if it is really corrupted)
repair table the_crashed_table (if needed)
Make sure there is no db access first before you do it. After that restart mysql and check log to see if the table is repaired.
1. backup database
2. under mysql prompt
check table the_crashed_table (to see if it is really corrupted)
repair table the_crashed_table (if needed)
Make sure there is no db access first before you do it. After that restart mysql and check log to see if the table is repaired.






