Consider the available command line options of mysqlbinlog. Which of the following statements are true?

The correct answer is A. --start-position will read the binlog entries starting at the specified position B. --end-position will read the binlog entries up to the specified position C. --start-datetime will read the binlog entries starting at the specified date and time D. --end-datetime will read the binlog entries up to the specified date and time. To handle partial-file extraction, mysqlbinlog supports options that enable you to specify the time or log position at which to begin extracting log contents:

Backup and Recovery

Question

Options

A--start-position will read the binlog entries starting at the specified position
B--end-position will read the binlog entries up to the specified position
C--start-datetime will read the binlog entries starting at the specified date and time
D--end-datetime will read the binlog entries up to the specified date and time
E--start-file will read the binlog entries starting with the specified filename
F--end-file will read the binlog entries ending after the specified filename

How the community answered

(25 responses)

A
84% (21)
E
4% (1)
F
12% (3)

Explanation

To handle partial-file extraction, mysqlbinlog supports options that enable you to specify the time or log position at which to begin extracting log contents:

Topics

#mysqlbinlog#binary log options#point-in-time recovery#restore

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice