You work as the Database Administrator for a MySQL database server. In an hour or so, you are able
to bring a corrupted server online. You execute the CHECK TABLE command and find that some of
the InnoDB tables need to be repaired. You restart the server and discover that auto-recover has
failed. Which of the following steps will you take to recover the corrupted InnoDB tables?
A.
Run the ANALYZE TABLE command.
B.
Run the REPAIR TABLE command.
C.
Recover the tables from the last backup.
D.
Run the OPTIMIZE TABLE command.
E.
Restart the server with the innodb_force_recovery option.
Explanation:
According to the question, the corrupted InnoDB tables are not auto-recovered. In such a case, you
will have to restart the server with the innodb_force_recovery option. Further, you can dump the
table, restart the server normally, and recover the tables from the dump file.