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?
A.
Binary log files
B.
My.ini
C.
My.cnf
D.
Master.info
Explanation:
The Binary log is a log file that contains a record of statements that modify data. This log is stored in
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 part of a multiple-statement transaction are written
as a 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.
The binary log is a set of files that contain information about data modifications made by the MySQL
the Configuration File – my.ini or my.cnf on Windows