Which of the following statements are correct regarding recovery of the InnoDB tables after a server
crash? Each correct answer represents a complete solution. Choose all that apply.

A.
They can only be recovered from the dump files.

B.
They are automatically recovered at the server startup.

C.
They are recovered only after restarting the server with the innodb_force_recovery option
configured.

D.
The innodb_force_recovery option opens the InnoDB tables in the read-only mode.

Explanation:
In the event of a crash, some InnoDB tables might need repairs. Simply restarting the server may
repair the tables because the InnoDB
storage engine performs auto-recovery as part of its startup sequence. In case auto-recovery does
not work, you need to open the InnoDB
tables in the read-only mode through the innodb_force_recovery option and dump the table to get
it recovered by restarting the server normally and recovering tables from the dump file.
Answer C is incorrect. Automatic recovery of the InnoDB table is performed as a part of its startup
sequence.
Answer A is incorrect. The InnoDB tables can be recovered automatically from the dump files, from
the earlier backups.