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 InnoDBtables?
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_recoveryoption.
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 theserver
normally, and recover the tables from the dump file.
E: To investigate database page corruption, you might dump your tables from the database with SELECT … INTO OUTFILE. Usually, most of the data obtained in this way is intact. Serious corruption might cause SELECT * FROM tbl_name statements or InnoDB background operations to crash or assert, or even cause InnoDB roll-forward recovery to crash. In such cases, you can use the innodb_force_recovery option to force the InnoDB storage engine to start up while preventing background operations from running, so that you can dump your tables.