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


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


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.


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.


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


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