You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master…

Question

Options

• Ainclude-log-file
• Bmaster-binlog
• Cinclude-master-info
• Dmaster-data

• A
  3% (1)
• B
  3% (1)
• C
  6% (2)
• D
  89% (32)

Explanation

--master-data is the correct mysqldump option because it automatically appends a CHANGE MASTER TO statement to the dump file, recording the master's current binary log filename and position. This is exactly what a new slave needs to know where to begin replicating - without it, you'd have to manually determine the log position. Options A (include-log-file), B (master-binlog), and C (include-master-info) are fabricated names that do not exist in mysqldump's actual option set; they are plausible-sounding distractors designed to test whether you know the real flag.

Memory tip: Think of it as "dump the master's data about its log position" - the word data in --master-data refers to the metadata about the master (log file + position), not the table data itself.

No community discussion yet for this question.