dump

Saves a table to files. backup table is the same command.

Syntax

dump table TABLE_NAME;
backup table TABLE_NAME;

Rules

• You need the DUMP privilege.
• The table, or the whole cluster, must be locked (lock table T;). This is what gives you a consistent copy.
• Every partition must have at least one available segment.

What happens

The command answers Backup started on N servers. and the work goes on in the background. Each SQL broker saves its share of the partitions in its backup directory (the last field of its SQL_BROKER line), one file per partition: TABLE_PARTITION_BACKUPID.sql. A table with several copies is saved once.

show backups for TABLE; lists the backups with their date and their status (Started, Terminated, Aborted). Do not unlock the table before they are Terminated.

Restoring

See restore.