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.
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.
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.