Outdated Version

You are viewing an older version of this section. View current production version.

DATABASE-RESTORE

MemSQL Ops has been deprecated

Please follow this guide to learn how to migrate to SingleStore tools.

Info

MemSQL Helios does not support this command.

Available since MemSQL Ops version 4.0.31.

Restore a MemSQL database from a backup.

Usage

usage: memsql-ops database-restore [--settings-file SETTINGS_FILE] [--async]
                                   [--no-prompt]
                                   [backup_id]

Restore a MemSQL database from a backup.

positional arguments:
  backup_id             The ID of the backup to use.

optional arguments:
  --settings-file SETTINGS_FILE
                        A path to a MemSQL Ops settings.conf file. If not set,
                        we will use the file in the same directory as the
                        MemSQL Ops binary.
  --async               If this option is true, we will exit without waiting
                        for the database to be fully restored.
  --no-prompt           Skip interactive prompts if ID is not provided. This
                        should be used for non-interactive scripts and
                        automation.