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