restore

Puts back the content of a table from a backup made with dump table.

Syntax

restore table TABLE_NAME [with [dump] id BACKUP_ID];

• Without with id, the most recent backup is used.
• BACKUP_ID is the number shown by show backups for TABLE_NAME;.

Rules

• You need the TRUNCATE and the INSERT privileges on the table.
• The table must exist, be deployed and be locked. The cluster must not be locked.
• The restore replaces the content of the table: the current rows are removed first.

Notes

The files of the backup must still be in the backup directories of the SQL brokers that made them. Run the restore when nobody writes to the table, and unlock it when the command has finished.