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 backup on 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?
在使用mysqlbackup命令备份的单个操作系统上运行有多个MySQL服务器实例。/etc/my/cnf包含默认值，例如datadir=/var/lib/mysql/，额外的实例有自己独立的my.cnf文件（例如/etc/mysql/instanceN.cnf）来覆盖默认值。尝试使用以下命令从mysqlbackup存档还原第二个实例：mysql backup–backup dir=/opt/backup/mysql/instance2复制回在启动第二个MySQL实例时，您注意到数据与预期的备份不匹配。成功更新第二个实例需要哪个命令行选项？
A. –restore=2
B. —copy-back-from-log
C–—backup-instance=/var–ib/mysql/instance2
D. —instance=/var/lib/my–l/instance2
E. —defaults-file=/etc/m–ql/instance2.cnf
Answer: E
解析:mysql 的启动参数默认从/etc/my.cnf 取得,如果要使用特定的参数文件来启动,需要使用—defaults-file

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL