innochecksum — Offline InnoDB File Checksum Utility Additional information: Undo page type: 0 insert, 0 update, 0 other Undo page state: 0 active, 0 cached, 0 to_free, 0 to_purge, 0 prepared, 0 other • --page-type-dump ,  -D Dump the page type information for each page in a tablespace to  stderr  or  stdout . Example usage: innochecksum --page-type-dump=/tmp/a.txt ../data/test/tab1.ibd Log output for the  innochecksum  tool. A log file name must be provided. Log output contains checksum values for each tablespace page. For uncompressed tables, LSN values are also provided. The  --log replaces the  --debug  option, which was available in earlier releases. Example usage: Specify the  -  option to read from standard input. If the  -  option is missing when “read from standard in” is expected,  innochecksum  prints  innochecksum  usage information indicating that the “-”  option was omitted. Example usages: In this example,  innochecksum  writes the  crc32  checksum algorithm to  a.ibd  without changing the original  t1.ibd  file. The following examples demonstrate how to run  innochecksum  on multiple user-defined tablespace files ( .ibd  files). Run  innochecksum  for all tablespace ( .ibd ) files in the “test”  database: Run  innochecksum  for all tablespace files ( .ibd  files) that have a file name starting with “t” : Run  innochecksum  for all tablespace files ( .ibd  files) in the  data  directory: Running  innochecksum  on multiple user-defined tablespace files is not supported on Windows operating systems, as Windows shells such as  cmd.exe  do not support glob pattern expansion. On Windows systems,  innochecksum  must be run separately for each user-defined tablespace file. For example: • --log ,  -l • -  option. innochecksum --log=/tmp/log.txt ../data/test/tab1.ibd innochecksum -l /tmp/log.txt ../data/test/tab1.ibd cat t1.ibd | innochecksum - cat t1.ibd | innochecksum --write=crc32 - > a.ibd innochecksum ./data/test/*.ibd innochecksum ./data/test/t*.ibd innochecksum ./data/*/*.ibd innochecksum.exe t1.ibd innochecksum.exe t2.ibd innochecksum.exe t3.ibd Note Running innochecksum on Multiple User-defined Tablespace Files or: 559