These options are associated with single-file backups. You use
them in combination with the mysqlbackup
extract that pack or unpack
single-image backups. For usage information, see
Section 3.3.5, “Making a Single-File Backup”.
Specify the path name of the file used for a single-file backup. By default, the single-file backup is streamed to standard output, so that you can pipe it directly to other commands such as tape backup or ssh-related network commands.
You can optionally prefix the image name with
file: to signify file I/O (the default).
For tape backups, prefix the image name
Section 188.8.131.52, “Backing Up to Tape” for details about tape
Identifies a file or directory to extract from a single-file
backup. This option is used with the
extract command. If the argument
is a directory, all its files and subdirectory contents are
extracted. No pattern matching expression is allowed for the
argument. Optionally, you can also specify the
--dst-entry option to extract
the file or directory in a location different from its
original path name.
extracts only one file,
src-entry=meta extracts the entire
directory tree for the
Default: All entries are extracted.
Used with single-file backups to extract a single file or
directory to a user-specified path. Use of this option
requires specifying the
--src-entry option. This option
specifies the destination path for the selected entry in
backup image corresponding to entry specified by
option. The entry could point to a single file or single
directory. For example, to retrieve the comments file from a
backup image and store it as
/tmp/my-comments.txt, use a command
like the following:
mysqlbackup --src-entry=meta/comments.txt \ --dst-entry=/tmp/my-comments.txt \ --backup-image=/var/myimage.bki extract
Similarly, to extract all the contents of the
meta directory in a single-file backup
/data/my-meta, use a command like
mysqlbackup --src-entry=meta \ --dst-entry=/data/my-meta \ --backup-image=/var/myimage.bki extract
The specified path is a simple path name without any wildcard expansion or regular expressions.
Default: By default, original pathnames are used to create files in the local file system.
For tape backups, this option can be used as a hint to the Media Management Software (MMS) for the selection of media and policies. This name has nothing to do with MySQL database names. It is a term used by the MMS. See Section 184.108.40.206, “Backing Up to Tape” for usage details.
Path name of the SBT library used by software that manages
tape backups. If this is not specified, operating
system-specific search methods are used to locate
libobk.so (UNIX) or
orasbt.dll (Windows). See
Section 220.127.116.11, “Backing Up to Tape” for usage details.
Passes product-specific environment variables to Oracle Secure Backup or another SBT-compliant backup management product, as an alternative to setting and unsetting environment variables before and after each mysqlbackup invocation.
The parameter to this option is a comma-separated list of
key-value pairs, using syntax similar to that of the RMAN
tool for the Oracle Database. For example,
Consult the documentation for your backup management product
to see which of its features can be controlled through
environment variables. For example, the Oracle Secure Backup
environment variables such as
OB_RESOURCE_WAIT_TIME. You might set such
variables with the mysqlbackup by
specifying an option such as
If the argument string contains any whitespace or special
characters recognized by the command shell, enclose the
entire argument string in quotation marks. To escape an
equals sign or comma, use the
character. For example,
Disable generation of
manifest files for a
backup operation, which are
backup_content.xml present in the
Copyright © 2003, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices