How would you begin to manually repair the InnoDB tables?

Following a server crash, the automatic recovery of InnoDB fails.
How would you begin to manually repair the InnoDB tables?

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:



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Me

Me

A. but not sure

Steve

Steve

It asks for begin, meaning the first step, which is A.
You cannot do B or C with the server not started.

E

E

InnoDB doesn’t have repair or check.

A.