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.


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

  memsql-admin restore-backup [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 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


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