PrepAway - Latest Free Exam Questions & Answers

Which of these files store updates that have been made after the backup was made?

In addition to taking backups of your databases, you should also backup up files stated below. Which of these
files store updates that have been made after the backup was made?

PrepAway - Latest Free Exam Questions & Answers

A.
Binary log files

B.
My.ini

C.
My.cnf

D.
Master.info

Explanation:
The Binary log is a log file that contains a recordof statements that modify data. This log is storedin the binary
format and its contents can be
viewed using the mysqlbinlog utility. The Binary log is used for communication between the master and slave
replication servers, and can also
be used for data recovery. Statements that are partof a multiple-statement transaction are written asa group
after the transaction has been
committed. The log contains UPDATE and DELETE statements but does not contain the SELECT statement.
Answer C and B are incorrect. These are option files used by the server. These files contain configuration
information that must be
restored after a crash.
Answer D is incorrect. Replication slave servers create a master.info file that contains information needed for
connecting to the master
server.

One Comment on “Which of these files store updates that have been made after the backup was made?


Leave a Reply