Consider the three binary log files bin.00010, bin.00011 and bin.00012 which you want to restore data from. How should you process these files when using mysqlbinlog to satisfy inter-file…

The correct answer is B. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql. shell> mysqlbinlog bin.000050 bin.000051 bin.000052 | mysql All the binary log files that you want to process should be handled in a single mysqlbinlog command. There may be inter-file dependencies that will not be satisfied if you process them

Backup and Recovery

Question

Consider the three binary log files bin.00010, bin.00011 and bin.00012 which you want to restore data from. How should you process these files when using mysqlbinlog to satisfy inter-file dependencies?

Options

Ashell> mysqlbinlog bin.00010 | mysqlshell> mysqlbinlog bin.00011 | mysqlshell> mysqlbinlog
Bshell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql
CYou can use both of the above statements, i.e. process the files either in a group or separately.

How the community answered

(54 responses)

A
7% (4)
B
70% (38)
C
22% (12)

Explanation

shell> mysqlbinlog bin.000050 bin.000051 bin.000052 | mysql All the binary log files that you want to process should be handled in a single mysqlbinlog command. There may be inter-file dependencies that will not be satisfied if you process them

Topics

#mysqlbinlog#binary logs#point-in-time recovery#inter-file dependencies

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice