You are viewing an older version of this section. View current production version.
Restore data from a binary backup file.
RESTORE [DATABASE] db_name FROM "backup_path"
db_nameis the name of a MemSQL database.
backup_pathis the path used in BACKUP .
RESTOREcommand replays a binary backup file in the same manner in which MemSQL recovers a database snapshot during startup.
RESTOREoperation temporarily puts the database being restored into the
recovering snapshotstate. A database in this state cannot be queried. When the
RESTOREcommand finishes, it puts the database into the
onlinestate. (see :ref:
database_statesfor more information).
- The path
backup_pathneeds to be accessible by the
memsqldprocess. Paths are resolved relative to the
- This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands).
This MemSQL feature is only available in MemSQL Enterprise Edition. MemSQL Enterprise Edition includes 24x7 support and several enterprise-only features for critical deployments. For more information about MemSQL Community and MemSQL Enterprise, see the MemSQL Editions page.
The following example restores from the
memsql> RESTORE DATABASE memsql_demo FROM "./"; Query OK, 1 row affected, 2 warnings (44.52 sec)