Restore one or more backups to the cluster.

Usage

Restores a database from backup.

This command runs RESTORE DATABASE on the Master Aggregator.

Example:

memsql-admin restore-backup --repository "s3://foo/bar?region=eu-central-1" backup1 backup2

memsql-admin restore-backup -r azure://foo/bar $(memsql-admin list-backups -r azure://foo/bar -q)

memsql-admin restore-backup backup1 -r azure://foo/bar

Usage:
  memsql-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.memsql.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                    Toolbox configuration file path
      --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

Remarks

This command is interactive unless you use either the --yes or --json flags to override interactive behavior.

Was this Article Helpful?

Thanks For Your Feedback!