Which are three facts about backups with mysqldump?
A. will lock all storage engines for duration(期间) of backup
B. can back up a remote database server
C. allow a consistent backup to be taken
D. are able to back up specific items within a database
E. create automatically compressed backups
F. are always faster to restore than binary backups
Answer: BCD
The mysqldump command is frequently used to create an empty instance, or an instance including data, on a replica server in a replication configuration.
这个mysqldump命令是经常被用来创建一个空的实例或实例包括数据，在复制配置一个从服务器。http://www.cndba.cn/hbhe0316/article/22805http://www.cndba.cn/hbhe0316/article/22805

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

MYSQL