Which of the following files will you copy?

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?

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?

A.
Master.info

B.
My.ini

C.
Relay-log.info

D.
My.cnf

Explanation:
Replication slave servers create a master.info file that contains information needed for connecting to
the master server.
Answer C is incorrect. This file indicates the current progress in processing the relay logs.
Answer B and D are incorrect. These files contain configuration information that must be restored
after a crash.



Leave a Reply 0

Your email address will not be published. Required fields are marked *