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.

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.