WAIT {STARTED | COMPLETED} | NOWAIT snapshot_option : SNAPSHOTSTART | SNAPSHOTEND 

Successive backups are automatically identified sequentially, so the backup_id , an integer greater than or equal to 1, is optional; if it is omitted, the next available value is used. If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists . If used, the backup_id  must follow START BACKUP  immediately, before any other options are used. 

NDB 8.0.22 and later supports the creation of encrypted backups using ENCRYPT PASSWORD= password ; the password  must meet all of the following requirements: 

•Uses any of the printable ASCII characters except ! , ’ , " , $ , % , \ , and ^ 

•Is no more than 256 characters in length 

•Is enclosed by single or double quotation marks 

Starting with NDB 8.0.24, the PASSWORD  clause can be omitted from encryption_option . In this case, the management client prompts the user for a password. 

It is possible using PASSWORD  to set an empty password ( ’’  or "" ), but this is not recommended. 

An encrypted backup can be decrypted using any of the following commands: 

• ndb_restore --decrypt --backup-password= password 

• ndbxfrm --decrypt-password= password input_file output_file 

• ndb_print_backup_file -P password file_name 

NDB 8.0.24 and later supports the additional commands listed here: 

• ndb_restore --decrypt --backup-password-from-stdin 

• ndbxfrm --decrypt-password-from-stdin input_file output_file 

• ndb_print_backup_file --backup-password= password file_name 

• ndb_print_backup_file --backup-password-from-stdin file_name 

• ndb_mgm --backup-password-from-stdin --execute "START BACKUP ..." 

See the descriptions of these programs for more information, such as additional options that may be required. 

The wait_option  can be used to determine when control is returned to the management client after a START BACKUP  command is issued, as shown in the following list: 

• If NOWAIT  is specified, the management client displays a prompt immediately, as seen here: 

ndb_mgm> START BACKUP NOWAIT ndb_mgm> 

In this case, the management client can be used even while it prints progress information from the backup process. 

• With WAIT STARTED  the management client waits until the backup has started before returning control to the user, as shown here: 

ndb_mgm> START BACKUP WAIT STARTED 

