MySQL 8.4 Release Notes
25.5.17 ndb_print_backup_file — 打印 NDB 备份文件内容
ndb_print_backup_file obtains diagnostic information from a cluster backup file.
ndb_print_backup_file [-P password] file_namefile_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”.
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.
ndb_print_backup_file supports the options described in the following list.
-
--backup-key,-KCommand-Line Format --backup-key=keySpecify the key needed to decrypt an encrypted backup.
-
Command-Line Format --backup-key-from-stdinAllow 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=passwordType String Default Value [none]Specify the password needed to decrypt an encrypted backup.
-
Command-Line Format --backup-password-from-stdinAllow 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 0Control file directory number. Used together with
--print-restored-rows. -
Command-Line Format --defaults-extra-file=pathType String Default Value [none]Read given file after global files are read.
-
Command-Line Format --defaults-file=pathType String Default Value [none]Read default options from given file only.
-
Command-Line Format --defaults-group-suffix=stringType String Default Value [none]Also read groups with concat(group, suffix).
-
Command-Line Format --fragment-id=#Type Integer Default Value 0Fragment ID. Used together with
--print-restored-rows. -
Command-Line Format --help--usagePrint program usage information.
-
Command-Line Format --login-path=pathType String Default Value [none]Read given path from login file.
-
Command-Line Format --no-login-pathsSkips reading options from the login path file.
-
Command-Line Format --no-defaultsDo not read default options from any option file other than login file.
-
Command-Line Format --no-print-rowsDo not include rows in output.
-
Command-Line Format --print-defaultsPrint program argument list and exit.
-
Command-Line Format --print-header-wordsInclude header words in output.
-
Command-Line Format --print-restored-rowsInclude restored rows in output, using the file
LCP/, for which the values are set as follows:c/TtFf.ctl-
cis the control file number set using--control-directory-number -
tis the table ID set using--table-id -
fis the fragment ID set using--fragment-id
-
-
Command-Line Format --print-rowsPrint rows. This option is enabled by default; to disable it, use
--no-print-rows. -
Command-Line Format --print-rows-per-pagePrint rows per page.
-
Command-Line Format --rowid-file=pathType File name Default Value [none]File to check for row ID.
-
Command-Line Format --show-ignored-rowsShow ignored rows.
-
Command-Line Format --table-id=#Type Integer Default Value [none]Table ID. Used together with
--print-restored-rows. -
Command-Line Format --usageDisplay help text and exit; same as
--help. -
Command-Line Format --verbose[=#]Type Integer Default Value 0Verbosity level of output. A greater value indicates increased verbosity.
-
Command-Line Format --versionDisplay version information and exit.