Question 4
A keyfile has been generated as follows:
# openssl rand 32 –hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?
# mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile - -backup-dir=/var/tmp/backup backup-to-image
# mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup
# mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/tmp/backup backup-to-image
# mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile - -backup-dir=/var/tmp/backup backup-to-image
# mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup – timestamp backup
Correct answer: D
Explanation:
Reference: https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/meb-encryption.html
Reference: https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/meb-encryption.html