Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.3Mb
PDF (A4) - 40.4Mb
PDF (RPM) - 39.9Mb
HTML Download (TGZ) - 10.6Mb
HTML Download (Zip) - 10.6Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 241.2Kb
Man Pages (Zip) - 346.4Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster

22.4.31 ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster

The ndbxfrm utility, introduced in NDB 8.0.22, can be used to decompress, decrypt, and output information about files created by NDB Cluster that are compressed, encrypted, or both. It can also be used to compress or encrypt files.

Table 22.49 Command-line options for the ndbxfrm program

Format Description Added, Deprecated, or Removed

--compress,

-c

Compress file

ADDED: NDB 8.0.22

--decrypt-password=string

Use this password to decrypt file

ADDED: NDB 8.0.22

--encrypt-kdf-iter-count=#,

-k

Number of iterations used in key definition

ADDED: NDB 8.0.22

--encrypt-password=string

Use this password to encrypt file

ADDED: NDB 8.0.22

--help,

-?

Print usage information

ADDED: NDB 8.0.22

--info,

-i

Print file information

ADDED: NDB 8.0.22

--usage,

-?

Prints usage information; synonym for --help

ADDED: NDB 8.0.22

--version,

-V

Output version information

ADDED: NDB 8.0.22


Usage

ndbxfrm --info file[ file ...]

ndbxfrm --compress input_file output_file

ndbxfrm --decrypt-password=password  input_file output_file

ndbxfrm [--encrypt-ldf-iter-count=#] --encrypt-password=password  input_file output_file

Options

  • --compress, -c

    Compresses the input file, using the same compression method as is used for compressing NDB Cluster backups, and writes the output to an output file. To decompress a compressed NDB backup file that is not encrypted, it is necessary only to invoke ndbxfrm using the names of the compressed file and an output file (with no options required).

  • --decrypt-password=password

    Decrypts a file encrypted by NDB using the password supplied.

  • --encrypt-kdf-iter-count=#, -k #

    When encrypting a file, specifies the number of iterations to use for the encryption key. Requires the --encrypt-password option.

  • --encrypt-password=password

    Encrypts the backup file using the password supplied by the option. The password must meet the requirements listed here:

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

    • Contains at least 1 character but is no more than 256 characters in length

    • Is enclosed by single or double quotation marks

    Because ndbxfrm expects to find a secret key in any files to be encrypted or decrypted, it can perform these tasks only with backup files created using NDB Cluster 8.0.22 or later.

  • --help, -?

    Prints usage information for the program.

  • --info, -i

    Prints the following information about one or more input files:

    • The name of the file

    • Whether the file is compressed (compression=yes or compression=no)

    • Whether the file is encrypted (encryption=yes or encryption=no)

    Example:

    shell> ndbxfrm -i BACKUP-10-0.5.Data BACKUP-10.5.ctl BACKUP-10.5.log
    File=BACKUP-10-0.5.Data, compression=no, encryption=yes
    File=BACKUP-10.5.ctl, compression=no, encryption=yes
    File=BACKUP-10.5.log, compression=no, encryption=yes
  • --usage, -?

    Synonym for --help.

  • --version, -V

    Prints out version information.

Note

ndbxfrm does not take any of the options shown in Section 22.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”, other than those explicitly listed in this section (that is, --help, --usage, and --version).