NAME¶

pt-secure-collect - collect, sanitize, pack and encrypt data.

SYNOPSIS¶

pt-secure-data [<flags>] <command> [<args> ...]

COMMANDS¶

• Help command

  Show help

• Collect command

  Collect, sanitize, pack and encrypt data from pt-tools. Usage:

  pt-secure-collect collect <flags>
  

  --bin-dir¶

  Directory having the Percona Toolkit binaries (if they are not in PATH).

  --temp-dir¶

  Temporary directory used for the data collection. Default: ${HOME}/data_collection_{timestamp}

  --include-dir¶

  Include this dir into the sanitized tar file.

  --config-file¶

  Path to the config file. Default: ~/.my.cnf

  --mysql-host¶

  MySQL host. Default: 127.0.0.1

  --mysql-port¶

  MySQL port. Default: 3306

  --mysql-user¶

  MySQL user name.

  --mysql-password¶

  MySQL password.

  --ask-mysql-pass¶

  password.

  --extra-cmd¶

  Also run this command as part of the data collection. This parameter can be used more than once.

  --encrypt-password¶

  Encrypt the output file using this password. If ommited, it will be asked in the command line.

  --no-collect¶

  Do not collect data

  --no-sanitize¶

  Do not sanitize data

  --no-encrypt¶

  Do not encrypt the output file.

  --no-sanitize-hostnames¶

  Do not sanitize hostnames.

  --no-sanitize-queries¶

  Do not replace queries by their fingerprints.

  --no-remove-temp-files¶

  Do not remove temporary files.

• Decrypt command

  Decrypt an encrypted file. The password will be requested from the terminal. Usage:

  pt-secure-collect decrypt [flags] <input file>
  

  --outfile¶

  Write the output to this file. If ommited, the output file name will be the same as the input file, adding the .aes extension.

• Encrypt command

  Encrypt a file. The password will be requested from the terminal. Usage:

  pt-secure-collect encrypt [flags] <input file>
  

  --outfile¶

  Write the output to this file. If ommited, the output file name will be the same as the input file, without the .aes extension.

• Sanitize command

  Replace queries in a file by their fingerprints and obfuscate hostnames. Usage:

  pt-secure-collect sanitize [flags]
  

  --input-file¶

  Input file. If not specified, the input will be Stdin.

  --output-file¶

  Output file. If not specified, the input will be Stdout.

  --no-sanitize-hostnames¶

  Do not sanitize host names.

  --no-sanitize-queries¶

  Do not replace queries by their fingerprints.