Appearance
ybbackup Options
This section contains detailed descriptions of the ybbackup
command-line options.
See also:
Note the following points about the format of these options and their values:
- Options are listed in alphabetical order for quick reference.
- Option names are shown in lowercase; they are case-sensitive.
- Specific valid option values (such as
true
andfalse
) are shown in lowercase. Variables for option values, such asSTRING
, are shown in uppercase. Option values are not case-sensitive. - The requirements for quoting option strings vary by client platform. Values are shown without quotes, but quotes are sometimes required. For example, if you specify the
#
character in a Linux shell, it must be enclosed by single or double quotes.
Note: Storage locations for backup files are not prefaced with an option name. See Storage Locations for Backups.
To see all of these options in the online help, run the ybbackup --help
and ybbackup --help-advanced
commands.
- -c STRING, --chain STRING
Specify the name of the backup chain. You can use any meaningful name that defines the contents of a particular backup set. If you do not specify this option, the chain is named
default
.Multiple chains and databases may be backed up to the same storage location. Backups that belong to different chains and databases are stored in distinct sets of files.
- --compatibility-mode BACKWARD | FORWARD | ALL | NONE
Allow/forbid running commands on backup bundles with newer/older bundle versions than the client tools bundle version.
BACKWARD
allows operating on backup bundles with bundle versions same as or older than the client tools bundle version.FORWARD
allows operating on backup bundles with bundle versions same as or newer than the client tools bundle version.ALL
allows operating on all backup bundles.NONE
allows operating on backup bundles with the same bundle version as the client tools bundle version.
By default BACKWARD
is chosen.
- -C, --cumu
Use this option to take a cumulative backup.
- -d, --dbname
Name the database to back up. You must specify one database only.
- --desc STRING
Include a description of the backup. The maximum length is 256 characters.
- --exclude SCHEMA
Specify the names of schemas that you want to exclude from a full backup. Database objects that belong to the specified schemas will not be backed up. This option may only be used for full backups; however, all backups in a given chain must respect the exclude list as defined for the first full backup. You cannot define an exclude list in the first backup, then change it in a subsequent full backup. The system depends on a consistent scope for all the backups in a single backup chain.
You can use a comma-separated list or a wildcard character to specify multiple schemas. Do not include any blanks (space characters) in the list; they will be treated as part of the schema name. For example:
--exclude public,dev,new --exclude dev* --exclude yb*
- -f, --full
Use this option to take a full backup.
- -h, --host
Specify the database server host. Alternatively, you can set this value with the
YBHOST
environment variable. Defaults tolocalhost
.- -I, --inc
Use this option to take an incremental backup.
- --integrity-check NONE | FAST | STRICT
Specify integrity checking (checksum validation) of backup files after they have been written to storage, if required. Integrity checking has an impact on backup performance but also reduces the likelihood that subsequent restore operations will fail because backup files are corrupted.
NONE
(the default): no integrity checking; no impact on backup performance.FAST
: file-level integrity checking; reduces performance by a small percentage.STRICT
: stricter integrity checking, including packet placements inside each file; reduces performance by a greater amount.- --name
Specify a unique name (across all backup chains) for this backup snapshot. Do not try to reuse the same snapshot name within different backup chains.
The name must be no greater than 64 characters. Directory paths are not allowed. For example:
--name sept6_2019_premdb_weekly_cumu
The backup name must contain only the following valid ASCII characters:
- A-Z
- a-z
- 0-9
- _
Mixed-case names are allowed, and the backup storage file system must support Linux-style mixed-case file names.
The
--name
value in theybbackup
command corresponds to thesnapshot_name
in the output forybbackupctl
commands.- --retry-failed-backups, --no-retry-failed-backups
Enable retrying up to
--retry-per-table-max
times if a table fails to back up during the session. This option is only applicable to YBD instances that also support retrying.- --retry-per-table-max NUMBER
The maximum number of retry attempts for a single table before the program terminates with an error.
- --temp-workdir STRING
Use the specified location as a temporary working directory for backup bundle processing. By default, the current working directory is used. Backup and restore operations that write or read from object storage require a writable local directory during processing. When processing is finished, this directory is empty.