Which of the following files contain configuration information that must be restored after a MySQL database server has crashed?

Which of the following files contain configuration information that must be restored after a MySQL database
server has crashed? Each correct answer represents a complete solution. Choose two.

Which of the following files contain configuration information that must be restored after a MySQL database
server has crashed? Each correct answer represents a complete solution. Choose two.

A.
My.ini

B.
My.cnf

C.
Master.info

D.
Binary log files

Explanation:
Answer B and A
My.cnf and my.ini files are the option files used by a MySQL server. These files contain configuration
information that must be restored after a crash.
Answer D is incorrect. The binary logs store updates that have been made after the backup was made.Answer
C is incorrect. Replication slave servers create a master.info file that contains information needed for
connecting to the master server.



Leave a Reply 0

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