4.1.10 Single-File Backup Options

These options are associated with single-file backups. You use them in combination with the mysqlbackup subcommands backup-to-image, image-to-backup-dir, backup-dir-to-image, list-image, and extract that pack or unpack single-image backups. For usage information, see Section 3.3.5, “Making a Single-File Backup”.

--backup-image=IMAGE

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 withsbt:. See Section 3.3.5.2, “Backing Up to Tape with Oracle Secure Backup” for details about tape backups.

--src-entry=PATH

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.

For example: src-entry=meta/comments.txt extracts only one file, comments.txt, while src-entry=meta extracts the entire directory tree for the meta subdirectory.

Default: All entries are extracted.

--dst-entry=PATH

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 -src-entry=PATH 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 as /data/my-meta, use a command like the following:

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 or regular expressions.

Default: By default, original pathnames are used to create files in the local file system.

--sbt-database-name=NAME

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 3.3.5.2, “Backing Up to Tape with Oracle Secure Backup” for usage details.

--sbt-lib-path=PATH

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 3.3.5.2, “Backing Up to Tape with Oracle Secure Backup” for usage details.

--disable-manifest

Disable generation of manifest files for a backup operation, which are backup_create.xml and backup_content.xml present in the meta subdirectory.