Microsoft
98-364 · Question #43
You work as the Database Administrator for a MySQL database server. In an hour or so, you are able to bring a corrupted server online. You execute the CHECK TABLE command and find that some of the…
The correct answer is E. Restart the server with the innodb_force_recovery option. See the full explanation below for the reasoning.
Question
You work as the Database Administrator for a MySQL database server. In an hour or so, you are able to bring a corrupted server online. You execute the CHECK TABLE command and find that some of the InnoDB tables need to be repaired. You restart the server and discover that auto-recover has failed. Which of the following steps will you take to recover the corrupted InnoDB tables?
Options
- ARun the ANALYZE TABLE command.
- BRun the REPAIR TABLE command.
- CRecover the tables from the last backup.
- DRun the OPTIMIZE TABLE command.
- ERestart the server with the innodb_force_recovery option.
How the community answered
(22 responses)- B9% (2)
- C5% (1)
- D5% (1)
- E82% (18)
Community Discussion
No community discussion yet for this question.