Product Solutions Support
Try MemSQL

RESTORE

Info

This command is not supported in MemSQL Cloud.

Restore data from a binary backup file.

Syntax

RESTORE [DATABASE] db_name FROM "backup_path"

Remarks

Info

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.

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 useful?