Administrative and Utility Programs This option was added in MySQL 8.0.18. This section describes administrative programs and programs that perform miscellaneous utility operations. ibd2sdi  is a utility for extracting serialized dictionary information (SDI) from  InnoDB  tablespace files. SDI data is present all persistent  InnoDB  tablespace files. ibd2sdi  can be run on file-per-table tablespace files ( *.ibd  files), general tablespace files ( *.ibd files), system tablespace files ( ibdata*  files), and the data dictionary tablespace ( mysql.ibd ). It is not supported for use with temporary tablespaces or undo tablespaces. ibd2sdi  can be used at runtime or while the server is offline. During DDL operations,  ROLLBACK operations, and undo log purge operations related to SDI, there may be a short interval of time when ibd2sdi  fails to read SDI data stored in the tablespace. ibd2sdi  performs an uncommitted read of SDI from the specified tablespace. Redo logs and undo logs are not accessed. Invoke the  ibd2sdi  utility like this: ibd2sdi  supports multi-file tablespaces like the  InnoDB  system tablespace, but it cannot be run on more than one tablespace at a time. For multi-file tablespaces, specify each file: The files of a multi-file tablespace must be specified in order of the ascending page number. If two successive files have the same space ID, the later file must start with the last page number of the previous file + 1. ibd2sdi  outputs SDI (containing id, type, and data fields) in  JSON  format. ibd2sdi  supports the following options: Display a help message and exit. For example: 552 Usage: ./ibd2sdi [-v] [-c <strict-check>] [-d <dump file name>] [-n] filename1 [filenames] See http://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html for usage hints. -h, --help Display this help and exit. -v, --version Display version information and exit. -#, --debug[=name] Output debug log. See http://dev.mysql.com/doc/refman/8.0/en/dbug-package.html -d, --dump-file=name Dump the tablespace SDI into the file passed by user. Without the filename, it will default to stdout -s, --skip-data Skip retrieving data from SDI records. Retrieve only id and type. -i, --id=# Retrieve the SDI record matching the id passed by user. -t, --type=# Retrieve the SDI records matching the type passed by user. -c, --strict-check=name • --help ,  -h 4.6 Administrative and Utility Programs 4.6.1 ibd2sdi — InnoDB Tablespace SDI Extraction Utility ibd2sdi Options ibd2sdi [ options ]  file_name1  [ file_name2 file_name3 ... ] ibd2sdi ibdata1 ibdata2