Exit 1Z0-883 MySQL 5.6 Database Administrator
Question 4 of 5
0% complete
Q4 Single choice

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.

Previous Next