Documentation Home
MySQL Enterprise Backup 3.12 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb

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 restore 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.