innochecksum — Offline InnoDB File Checksum Utility ] Specifies a strict checksum algorithm for validating the checksum of pages that are read. Options include innodb ,  crc32 , and  none . In this example, the strict version of the  innodb  checksum algorithm is specified: In this example, the strict version of  crc32  checksum algorithm is specified: If you do not specify the  --strict-check  option, validation is performed against non-strict  innodb , crc32  and  none  checksums. Skips checksum validation for pages that are read. Outputs SDI data in JSON pretty print format. Enabled by default. If disabled, SDI is not human readable but is smaller in size. Use  --skip-pretty  to disable. innochecksum  prints checksums for  InnoDB  files. This tool reads an  InnoDB  tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file copies. Because checksum mismatches cause  InnoDB  to deliberately shut down a running server, it may be preferable to use this tool rather than waiting for an in-production server to encounter the damaged pages. innochecksum  cannot be used on tablespace files that the server already has open. For such files, you should use  CHECK TABLE  to check tables within the tablespace. Attempting to run  innochecksum  on a tablespace that the server already has open results in an  Unable to lock file  error. ibd2sdi --skip-pretty ../data/test/t1.ibd ibd2sdi --no-check ../data/test/t1.ibd ibd2sdi -c crc32 ../data/test/t1.ibd ibd2sdi --strict-check=innodb ../data/test/t1.ibd • --no-check ,  -n • --pretty ,  -p 4.6.2 innochecksum — Offline InnoDB File Checksum Utility innochecksum Options If checksum mismatches are found, restore the tablespace from backup or start the server and attempt to use  mysqldump  to make a backup of the tables within the tablespace. Invoke  innochecksum  like this: innochecksum [ options ]  file_name innochecksum  supports the following options. For options that refer to page numbers, the numbers are zero-based. Displays command line help. Example usage: • --help ,  -? 555 • --strict-check ,  -c