Following a server crash, the automatic recovery of InnoDB fails.
How would you begin to manually repair the InnoDB tables?
A.
Start the server with the – innodb_force_recovery option set to a non-zero value.
B.
Start the server as usual, and then execute the REPAIR TABLE command.
C.
Start the server as usual, and then execute the CHECK TABLE command.
D.
Start the server with the – innodb_recover_options option set to FORCE.
Explanation:
A. but not sure
It asks for begin, meaning the first step, which is A.
You cannot do B or C with the server not started.
InnoDB doesn’t have repair or check.
A.
should be A.
http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
A