MySQL 8.0 Database Administrator — Question 30

Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back
Which statement is true about the copy-back process?

Answer options

• A. The copy-back process is used to overwrite a new backup over an existing backup.
• B. It restores files from the data directory to their original MySQL server locations.
• C. It restores files from the backup directory to their original MySQL server locations.
• D. The copy-back process makes inconsistent backups.

Correct answer: A, C

Explanation

The correct answer is C because the copy-back process specifically involves restoring files from the backup directory back to the original locations on the MySQL server. Option A is incorrect as it describes overwriting rather than restoring, and the other options do not accurately describe the function of the copy-back process.