You have just executed a manual backup by using this command:

mysqlbackup -u root -p —socket=/tmp/my.sock —backup-dir=/my/backup/ backup

The operation completed without error.

What is the state of this backup and operation required before it is ready to be restored?

A. Backup State = Compressed Backup; Operation = copy-back

B. Backup State = Raw Backup; Operation = apply-log

C. Backup State = Prepared Backup; Operation = validate

D. Backup State = Prepared Backup; Operation = apply-log

E. Backup State = Raw Backup; Operation = backup-dir-to-imagehttp://www.cndba.cn/hbhe0316/article/22748http://www.cndba.cn/hbhe0316/article/22748

Answer: B

默认 compress 是关闭的,所以 backup state 不是 compressed 的
对于初始的 backup 产生的记录应当是初始记录的,需要使用 apply-log 来使得备份同步

备份其实主要的内容也就是 backup、 restore 和校验。 每个阶段使用的主要参数如下：
· Backup operations: backup, backup-and-apply-log, backup-to-image
· Update operations: apply-log, apply-incremental-backup
· Restore operations: copy-back, copy-back-and-apply-log
· Validation operation: validate Single-file backup
· operations: image-to-backup-dir, backup-dir-to-image, list-image, extract

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

MYSQL