Documentation Home
MySQL Enterprise Backup 3.12 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb
HTML Download (TGZ) - 174.2Kb
HTML Download (Zip) - 199.7Kb

5.2.1 Restoring a Compressed Backup

Restore a compressed directory backup at <backupDir> to <restoreDir> on the server using copy-back-and-apply-log and the --uncompress option:

Example 5.7 Restoring a Compressed Backup

mysqlbackup --defaults-file=<my.cnf> -uroot --backup-dir=<backupDir> --datadir=<restoreDir> \
  --uncompress copy-back-and-apply-log

To restored a compressed and prepared directory backup created with the backup-and-apply-log command (which is only supported for MySQL Enterprise Backup 3.12.3 and later), use the copy-back command and the --uncompress option:

mysqlbackup --defaults-file=<my.cnf> -uroot --backup-dir=<backupDir> --datadir=<restoreDir> \
  --uncompress copy-back

To restore a compressed backup image named <image_name>, use the copy-back-and-apply-log command and the --uncompress option, with the --backup-dir option specifying a temporary directory into which temporary output, status files, and backup metadata will be saved:

mysqlbackup --defaults-file=<my.cnf> -uroot --backup-image=<image_name> \
  --backup-dir=<backupTmpDir> --datadir=<restoreDir> --uncompress copy-back-and-apply-log

See Section 4.3.3, “Making a Compressed Backup” and Section 14.6, “Compression Options” for more details on compressed backups.

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.