Oracle Exam 1Z0-888 Topic 11 Question 32 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 32
Topic #: 11

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.

The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.

A restore of the second instance is attempted from the mysqlbackup archive using this command:

mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back

Upon starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?

A--restore=2

B--copy-back-from-log

C--backup-instance=/var/lib/mysql/instance2

D--instance=/var/lib/mysql/instance2

E--defaults-file=/etc/mysql/instance2.cnf

Show Suggested Answer

Suggested Answer: E

by Melodie at May 03, 2022, 02:43 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-888 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!