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).
MemSQL does not support restoring database backups from a newer version of MemSQL into an older version.
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 Developer 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)