Exit 1Z0-873 MySQL 5.0 Database Administrator Certified Professional Exam, Part I
Question 4 of 5
0% complete
Q4 Single choice

After a server crash, some InnoDB tables need to be repaired. However, when the server is restarted, auto-recover failed.

How would you repair the InnoDB tables?

  • A

    Restart the server with the --innodb_force_recovery option.

  • B

    Execute the REPAIR TABLE command.

  • C

    Execute the OPTIMIZE TABLE command.

Previous Next