MySQL repair: The storage engine for the table doesn't support repair

Question

Why the message appears in Repair a MySQL database? Please see attached

Answer

MySQL table repairs only support specific table types. If the repair command is performed on an InnoDB table, this error will appear. Please see the MySQL official documentation for supported table types with the repair command.

MySQL Repair Table

Supported formats are:

MyISAM

ARCHIVE

CSV tables

InnoDB tables have built-in repair functions during restarts. If a manual repair is required due to corrupted tables, the InnoDB recovery options can be used.

MySQL InnoDB Recovery

Note: InnoDB Recovery requires a certified systems administrator to perform in the event data is corrupted. Please consult with your systems administrator for further assistance if a repair is required due to InnoDB's data corruption.

Please utilize the below guide to determine if InnoDB is corrupted.

How do I identify InnoDB corruption