Skip to main content Link Menu Expand (external link) Document Search Copy Copied

Backup and Restore


For RPDSQL

Syntax:

BACKUP [DATABASE] db_name [WITH { INIT | DIFFERENTIAL | SPLIT PARTITIONS [BY 2] }] TO "backup_path" [(OPTION resource_pool = resource_pool_name)]

RESTORE [DATABASE] db_name FROM "backup_path" [WITH FILE incr_backup_id] [sync_options] [(OPTION resource_pool = resource_pool_name)]

Example:

BACKUP testdata TO "/home/testdata";

RESTORE DATABASE testdata from "/home/testdata";

For MOXE

Refer to RapidsDB Installation and Management Guide:

  • Chapter 8.5 Backing up and Restoring MOXE Tables