Documentation Home
MySQL Enterprise Backup 4.0 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb
HTML Download (TGZ) - 181.6Kb
HTML Download (Zip) - 212.8Kb


MySQL Enterprise Backup 4.0 User's Guide  /  ...  /  Restoring a Backup from Cloud Storage to a MySQL Server

5.1.5 Restoring a Backup from Cloud Storage to a MySQL Server

To restore a backup image from cloud storage to datadir on the server, use the cloud storage options, and also the --backup-dir option to specify the temporary directory into which temporary output, status files, and backup metadata will be saved:

Example 5.9 Restoring a Single-file Backup from an Oracle Cloud Storage Service Instance to a MySQL Server

mysqlbackup \
--defaults-file=/bkups/backupdir/backupmy.cnf \
--cloud-service=openstack  --cloud-container=<oracle storage cloud container> \
--cloud-user-id=<serviceInstanceName>-<identityDomainName>:<userName> --cloud-password=<password> \
--cloud-tempauth-url=https://<dataCenterCode>.storage.oraclecloud.com \
--cloud-object=<backup_image_name> \
--datadir=/home/user/dba/datadir \ 
--backup-dir=/home/user/dba/orbackuptmpdir \
--backup-image=- \
copy-back-and-apply-log

Example 5.10 Restoring a Single-file Backup from an OpenStack Object Storage to a MySQL Server

mysqlbackup \
--defaults-file=/bkups/backupdir/backupmy.cnf \
--cloud-service=openstack  --cloud-container=<swift container> \
--cloud-user-id=<keystone user> --cloud-password=<keystone password> \
--cloud-region=<keystone region> --cloud-tenant=<keystone tenant> \
--cloud-identity-url=<keystone url> --cloud-object=image_800.mbi \
--backup-dir=/home/user/dba/swiftbackuptmpdir \
--datadir=/home/user/dba/datadir \ 
--backup-image=- \
copy-back-and-apply-log

Example 5.11 Restoring a Single-file Backup from Amazon S3 to a MySQL Server

mysqlbackup\
--defaults-file=/bkups/backupdir/backupmy.cnf \
--cloud-service=s3 --cloud-aws-region=<aws region> \
--cloud-access-key-id=<aws access key id> --cloud-secret-access-key=< aws secret access key> \
--cloud-bucket=<s3 bucket name> --cloud-object-key=<aws object key> \
--backup-dir=/home/user/dba/s3backuptmpdir \
--datadir=/home/user/dba/datadir \
--backup-image=- \
copy-back-and-apply-log


User Comments
Sign Up Login You must be logged in to post a comment.