MySQL Enterprise Backup User's Guide (Version 3.11.1)
To simplify transfer and management of backup data, you can
keep each backup in a single file (the backup image). The
backup-to-image
option performs a
backup directly to a single file, or the options here can pack
an existing backup into a single file or unpack a single-file
backup to a full backup directory structure. There are other
options for working with single-file backups, which are
explained below. For usage and examples, see
Section 3.3.5, “Making a Single-File Backup”.
mysqlbackup [STD-OPTIONS] [--backup-image
=IMAGE
] [--backup-dir
=PATH
] [MESSAGE-LOGGING-OPTIONS] [PROGRESS-REPORT-OPTIONS] [ENCRYPTION-OPTIONS] [CLOUD-STORAGE-OPTIONS]image-to-backup-dir
mysqlbackup [STD-OPTIONS] [--backup-dir
=PATH
] [--backup-image
=IMAGE
] [MESSAGE-LOGGING-OPTIONS] [PROGRESS-REPORT-OPTIONS] [ENCRYPTION-OPTIONS] [CLOUD-STORAGE-OPTIONS]backup-dir-to-image
mysqlbackup [STD-OPTIONS] [--backup-image
=IMAGE
] [--src-entry
=PATH
] [MESSAGE-LOGGING-OPTIONS] [ENCRYPTION-OPTIONS] [CLOUD-STORAGE-OPTIONS]list-image
mysqlbackup [STD-OPTIONS] [--backup-image
=IMAGE
] [--backup-dir
=PATH
] [--src-entry
=PATH
] [--dst-entry
=PATH
] [MESSAGE-LOGGING-OPTIONS] [PROGRESS-REPORT-OPTIONS] [ENCRYPTION-OPTIONS] [CLOUD-STORAGE-OPTIONS]extract
mysqlbackup [STD-OPTIONS] [SERVER-REPOSITORY-OPTIONS] [--backup-image
=IMAGE
] [--backup-dir
=PATH
] [MESSAGE-LOGGING-OPTIONS] [PARTIAL-BACKUP-RESTORE-OPTIONS] [PROGRESS-REPORT-OPTIONS] [ENCRYPTION-OPTIONS] [CLOUD-STORAGE-OPTIONS]copy-back-and-apply-log
image-to-backup-dir
Unpacks a single-file backup to a full backup directory structure. You specify the paths to both the image file and the destination directory in which to unpack. For usage and examples, see Section 3.3.5, “Making a Single-File Backup”.
backup-dir-to-image
Packs an existing backup into a single file. Specify a
--backup-image
value of
-
(standard output) to stream an
existing backup directory structure to a tape device or a
command that transfers the backup to another server. The
--backup-image
parameter is either
-
or an absolute path outside the
backup-dir
directory. For usage and
examples, see Section 3.3.5, “Making a Single-File Backup”.
list-image
Display the contents of a single-file backup. Lists all
files and directories in the image. The
--src-entry=
can be used to list a specific file or directory. If the
name is a directory, all its files and subdirectories
inside the image are recursively listed. For usage and
examples, see
Section 3.3.5, “Making a Single-File Backup”.
name
The list-image
operation
can be performed on a cloud backup only if the cloud
proxy supports range headers.
extract
Unpacks an individual file or directory from a single-file
backup. For troubleshooting or restoration operations that
do not require the full set of backup data. The resulting
file or directory goes in the current directory, or in
backup-dir
if specified. All files and
directory contents in the image with absolute path names
are extracted into the same absolute path names on the
local system. For usage and examples, see
Section 3.3.5, “Making a Single-File Backup”.
The
--src-entry=
option can be used for selective extraction of a single
file or single directory in image. Specify the path as it
appears in the image.
path
The
--dst-entry=
option, along with
path
--src-entry=
option can be used to extract a single file or single
directory into a user-specified file or directory
respectively. If the path
--src-entry
option
is used, but --dst-entry
option is
omitted, then the selected file or directory is extracted
to the same path in the local file system.
The default destination for the extract is the current
working directory. It can be overridden by the
--backup-dir
option. All the
files with relative pathnames in the image are extracted
to pathnames relative to the destination directory.
If the image contains some entries with absolute
pathnames, those entries are extracted to the same
absolute path names even if --backup-dir
option is specified. The
--dst-entry
option must be
used to relocate an absolute pathname.
copy-back-and-apply-log
See description for
copy-back-and-apply-log
in
Section 5.1.1.3, “Restore an Existing Backup”.