Oracle
1Z0-888 · Question #46
1Z0-888 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
Backup and Recovery
Question
There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqldump 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?
Options
- 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
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#mysqlbackup#restore operations#multi-instance setup#--defaults-file