content_image/703679.jpg
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 , -l 

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: 

innochecksum --log=/tmp/log.txt ../data/test/tab1.ibd 

or: 

innochecksum -l /tmp/log.txt ../data/test/tab1.ibd 

• -  option. 

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: 

cat t1.ibd | innochecksum - 

In this example, innochecksum  writes the crc32  checksum algorithm to a.ibd  without changing the original t1.ibd  file. 

cat t1.ibd | innochecksum --write=crc32 - > a.ibd 

## Running innochecksum on Multiple User-defined Tablespace Files 

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: 

innochecksum ./data/test/*.ibd 

Run innochecksum  for all tablespace files ( .ibd  files) that have a file name starting with “t” : 

innochecksum ./data/test/t*.ibd 

Run innochecksum  for all tablespace files ( .ibd  files) in the data  directory: 

innochecksum ./data/*/*.ibd 

<img src='content_image/703679.jpg'>

## Note 

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: 

innochecksum.exe t1.ibd innochecksum.exe t2.ibd innochecksum.exe t3.ibd 

