MySQL 8.4 Release Notes
ndb_print_backup_file 从集群备份文件中获取诊断信息。ndb_print_backup_file obtains diagnostic information from a cluster backup file.
用法Usage
ndb_print_backup_file [-Ppassword]file_name
file_name 是集群备份文件的名称。它可以是集群备份目录中找到的任何文件（.Data、.ctl 或 .log 文件）。这些文件位于数据节点的备份目录下的子目录 BACKUP- 中，其中 ## 是备份的序列号。有关集群备份文件及其内容的更多信息，请参阅 第 25.6.8.1 节，“NDB 集群备份概念”。file_name is the name of a cluster
backup file. This can be any of the files
(.Data, .ctl, or
.log file) found in a cluster backup
directory. These files are found in the data node's backup
directory under the subdirectory
BACKUP-, where
## is the sequence number for the
backup. For more information about cluster backup files and
their contents, see
Section 25.6.8.1, “NDB Cluster Backup Concepts”.
像 ndb_print_schema_file 和 ndb_print_sys_file（不同于大多数其他 NDB 工具，这些工具通常用于在管理服务器主机上运行或连接到管理服务器）ndb_print_backup_file 必须在集群数据节点上运行，因为它直接访问数据节点文件系统。由于它不使用管理服务器，因此当管理服务器未运行时，甚至在集群完全关闭时也可以使用该工具。Like ndb_print_schema_file and
ndb_print_sys_file (and unlike most of the
other NDB utilities that are
intended to be run on a management server host or to connect to
a management server) ndb_print_backup_file
must be run on a cluster data node, since it accesses the data
node file system directly. Because it does not make use of the
management server, this utility can be used when the management
server is not running, and even when the cluster has been
completely shut down.
该程序也可以用于读取撤消日志文件。This program can also be used to read undo log files.
选项Options
ndb_print_backup_file 支持以下列表中描述的选项。ndb_print_backup_file supports the options described in the following list.
--backup-key,-K命令行格式Command-Line Format --backup-key=key指定解密加密备份所需的密钥。Specify the key needed to decrypt an encrypted backup.
命令行格式Command-Line Format --backup-key-from-stdin允许从标准输入输入解密密钥，类似于在调用 mysql 时未提供密码而输入
--password后输入密码的方式。Allow input of the decryption key from standard input, similar to entering a password after invoking mysql--passwordwith no password supplied.命令行格式Command-Line Format --backup-password=password类型Type 字符串String 默认值Default Value [none][none]指定解密加密备份所需的密码。Specify the password needed to decrypt an encrypted backup.
命令行格式Command-Line Format --backup-password-from-stdin允许从标准输入输入密码，类似于在调用 mysql
--password时未提供密码后输入密码。Allow input of the password from standard input, similar to entering a password after invoking mysql--passwordwith no password supplied.命令行格式Command-Line Format --control-directory-number=#类型Type 整数Integer 默认值Default Value 0控制文件目录编号。与
--print-restored-rows一起使用。Control file directory number. Used together with--print-restored-rows.命令行格式Command-Line Format --defaults-extra-file=path--defaults-extra-file=path类型Type 字符串String 默认值Default Value [none][none]在读取全局文件之后读取给定文件。Read given file after global files are read.
命令行格式Command-Line Format --defaults-file=path类型Type 字符串String 默认值Default Value [none][none]仅从指定文件读取默认选项。Read default options from given file only.
命令行格式Command-Line Format --defaults-group-suffix=string类型Type 字符串String 默认值Default Value [none][none]也读取组合了 concat(group, suffix) 的组。Also read groups with concat(group, suffix).
命令行格式Command-Line Format --fragment-id=#类型Type 整数Integer 默认值Default Value 0片段 ID。与
--print-restored-rows一起使用。Fragment ID. Used together with--print-restored-rows.命令行格式Command-Line Format --help--help--usage打印程序使用信息。Print program usage information.
命令行格式Command-Line Format --login-path=path类型Type 字符串String 默认值Default Value [none][none]从登录文件读取给定路径。Read given path from login file.
命令行格式Command-Line Format --no-login-paths跳过从登录路径文件读取选项。Skips reading options from the login path file.
命令行格式Command-Line Format --no-defaults--no-defaults除了登录文件之外，不从任何配置文件读取默认选项。Do not read default options from any option file other than login file.
命令行格式Command-Line Format --no-print-rows输出中不包含行。Do not include rows in output.
命令行格式Command-Line Format --print-defaults打印程序参数列表然后退出。Print program argument list and exit.
命令行格式Command-Line Format --print-header-words在输出中包含头部词。Include header words in output.
命令行格式Command-Line Format --print-restored-rows在输出中包括已恢复的行，使用文件
LCP/，其值设置如下：Include restored rows in output, using the filec/TtFf.ctlLCP/, for which the values are set as follows:c/TtFf.ctlc是使用--control-directory-number设置的控制文件编号cis the control file number set using--control-directory-numbert是使用--table-id设置的表 IDtis the table ID set using--table-idf是使用--fragment-id设置的分片 IDfis the fragment ID set using--fragment-id
命令行格式Command-Line Format --print-rows打印行。此选项默认启用；要禁用它，请使用
--no-print-rows。Print rows. This option is enabled by default; to disable it, use--no-print-rows.命令行格式Command-Line Format --print-rows-per-page每页打印行。Print rows per page.
命令行格式Command-Line Format --rowid-file=path类型Type 文件名File name 默认值Default Value [none][none]用于检查行 ID 的文件。File to check for row ID.
命令行格式Command-Line Format --show-ignored-rows显示被忽略的行。Show ignored rows.
命令行格式Command-Line Format --table-id=#类型Type 整数Integer 默认值Default Value [none][none]表 ID。与
--print-restored-rows一起使用。Table ID. Used together with--print-restored-rows.命令行格式Command-Line Format --usage显示帮助文本并退出；与
--help相同。Display help text and exit; same as--help.命令行格式Command-Line Format --verbose[=#]类型Type 整数Integer 默认值Default Value 0输出的详细程度。值越大表示详细程度越高。Verbosity level of output. A greater value indicates increased verbosity.
命令行格式Command-Line Format --version显示版本信息并退出。Display version information and exit.