Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
SingleStore Managed Service does not support this command.
Restore one or more full and split backups to the cluster.
Restores a database from full and split backup.
This command runs RESTORE DATABASE on the Master Aggregator.
Example:
sdb-admin restore-backup --repository "s3://foo/bar?region=eu-central-1" backup1 backup2
sdb-admin restore-backup -r azure://foo/bar $(sdb-admin list-backups -r azure://foo/bar -q)
sdb-admin restore-backup backup1 -r azure://foo/bar
Usage:
sdb-admin restore-backup [flags]
Flags:
--database-prefix string Prepend the specified prefix to each database name created during restore
--database-suffix string Append the specified suffix to each database name created during restore
--full-checksum Perform a full CRC32C check on each backup before restoring
-h, --help Help for restore-backup
-r, --repository STRING Path to the repository location. Must be specified in URL format, see https://docs.singlestore.com/toolbox-redir/memsql-backup-repository for examples
--timeout duration Maximum time to wait for backup to be restored (e.g., 30s, 10m, 1.5h); defaults to 24 hours (default 24h0m0s)
Global Flags:
--backup-cache FILE_PATH File path for the backup cache
--cache-file FILE_PATH File path for the Toolbox node cache
-c, --config FILE_PATH File path for the Toolbox configuration
--disable-colors Disable colored output in console, which some terminal sessions/environments may have issues with
--disable-spinner Disable the progress spinner, which some terminal sessions/environments may have issues with
-j, --json Enable JSON output
--parallelism POSITIVE_INTEGER Maximum number of operations to run in parallel
--runtime-dir DIRECTORY_PATH Where to store Toolbox runtime data
--ssh-max-sessions POSITIVE_INTEGER Maximum number of SSH sessions to open per host, must be at least 3
--state-file FILE_PATH Toolbox state file path
-v, --verbosity count Increase logging verbosity: valid values are 1, 2, 3. Usage -v=count or --verbosity=count
-y, --yes Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default
This command is interactive unless you use either the --yes
or --json
flags to override interactive behavior.