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 .
- If you wish to restore the backup into a differently named database, you can do so by specifying the full path to the .backup file in
backup_path. For example, you can do
BACKUP DATABASE db TO './path/'followed by
RESTORE DATABASE newdb FROM './path/db.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 the Database topic for 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)