Here is how to fix a corrupted table (note the single ‘s and {} pairs are not part of the sql commands but are used for clarity and that the “;” are required):
- Log into mysql as administrator
- select the database containing the corrupted table, i.e., ‘use {database name};’
- ‘show tables;’ your corrupted table should be listed
- ‘repair table {bad_table_name};’
- ‘unlock tables;’
Done