Product Solutions Support
Try MemSQL

BACKUP

Info

This command is not supported in MemSQL Cloud.

Back up data to a binary file.

BACKUP [DATABASE] db_name TO "backup_path"

Notes

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 creates a backup on each node in the /var/lib/memsql/data directory.

mysql> BACKUP DATABASE memsql_demo to "./";
Query OK, 1 row affected (6.32 sec)
Was this article useful?