Big 11.11 Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle MySQL 5.7 Database Administrator 1z0-888 Question # 30 Topic 4 Discussion

Oracle MySQL 5.7 Database Administrator 1z0-888 Question # 30 Topic 4 Discussion

1z0-888 Exam Topic 4 Question 30 Discussion:
Question #: 30
Topic #: 4

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


Get Premium 1z0-888 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.