Restore data from a binary backup file.

RESTORE [DATABASE] db_name FROM "backup_path"

• db_name is the name of a MemSQL database.
• backup_path is the path used in BACKUP .
• The RESTORE command replays a binary backup file in the same manner in which MemSQL recovers a database snapshot during startup.
• A RESTORE operation temporarily puts the database being restored into the recovering snapshot state. A database in this state cannot be queried. When the RESTORE command finishes, it puts the database into the online state. (see :ref:database_states for more information).
• The path backup_path needs to be accessible by the memsqld process. Paths are resolved relative to the memsqlbin/data directory.
• This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands).

Example

The following example restores from the /var/lib/memsql/data/ directory.

memsql> RESTORE DATABASE memsql_demo FROM "./";
Query OK, 1 row affected, 2 warnings (44.52 sec)

Was this Article Helpful?

Thanks For Your Feedback!