Oracle
1Z0-883 · Question #82
Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data. Which method would use mysqlbinlog for greater consistency?
The correct answer is B. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql. See the full explanation below for the reasoning.
Question
Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data. Which method would use mysqlbinlog for greater consistency?
Options
- Ashell> mysqlbinlog bin.00010 | mysql
- Bshell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql
- Cshell> mysqlbinlog restore bin.00010 bin.00011 bin.00012
- Dshell> mysqlbinlog include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql
How the community answered
(15 responses)- A7% (1)
- B73% (11)
- C13% (2)
- D7% (1)
Community Discussion
No community discussion yet for this question.