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 serverwith the innodb_force_recovery option configured.
D.
The innodb_force_recovery option opens the InnoDB tables in the read-only mode.
Explanation:
Answer B and DIn 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 partof its startup sequence.
Answer A is incorrect. The InnoDB tables can be recovered automatically from the dump files, from the earlier
backups.