Restore data from a binary backup file.

Syntax

RESTORE [DATABASE] db_name FROM "backup_path"

Remarks

• db_name is the name of a MemSQL database.
• backup_path is 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'
• 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 the Database topic 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!