Database Fundamentals — Question 149

You are taking back up of your MySQL database server.
You need to take a back up of the file that has been created by the replication slave server and contains information needed for connecting to the master server.
Which of the following files will you copy?

Answer options

• A. Master.info
• B. My.ini
• C. Relay-log.info
• D. My.cnf

Correct answer: A

Explanation

The correct answer is A, Master.info, because this file contains the necessary connection details for the replication slave to connect to the master server. The other options, such as My.ini and My.cnf, are configuration files, while Relay-log.info contains information about the relay logs, not the master connection details.