1Z0-873 · Question #57
Which of the following steps should be taken to restore an InnoDB table to a consistent state without having to shutdown the server?
The correct answer is B. Dump the table with mysqldump, drop the table then re-create from the dump file. If a table check indicates that an InnoDB table has problems, you should be able to restore the table to a consistent state by dumping it with mysqldump, dropping it, and re-creating it from the shell> mysqldump db_name table_name > dump_file shell> mysql db_name < dump_file
Question
Which of the following steps should be taken to restore an InnoDB table to a consistent state without having to shutdown the server?
Options
- ARun the REPAIR TABLE command.
- BDump the table with mysqldump, drop the table then re-create from the dump file.
- CRun the CHECK TABLE command.
- DDump the table with mysqlhotcopy, drop the table then re-create with the backup file.
How the community answered
(21 responses)- A5% (1)
- B81% (17)
- C5% (1)
- D10% (2)
Explanation
If a table check indicates that an InnoDB table has problems, you should be able to restore the table to a consistent state by dumping it with mysqldump, dropping it, and re-creating it from the shell> mysqldump db_name table_name > dump_file shell> mysql db_name < dump_file
Topics
Community Discussion
No community discussion yet for this question.