IBD2SDI(1) MySQL Database System IBD2SDI(1) (NAME) ibd2sdi - InnoDB (SDI) InnoDB (SYNOPSIS) ibd2sdi [options] file_name1 [file_name2 file_name3 ...] (DESCRIPTION) ibd2sdi [1] (SDI) InnoDB . SDI InnoDB . ibd2sdi file-per-table ( *.ibd) ( *.ibd) [2] ( *ibdata) (mysql.ibd) . undo . ibd2sdi . DDL ROLLBACK (purge) undo SDI ibd2sdi SDI . ibd2sdi (uncommitted read) SDI . redo undo . ibd2sdi : ibd2sdi [options] file_name1 [file_name2 file_name3 ...] ibd2sdi InnoDB . : ibd2sdi ibdata1 ibdata2 . + . ibd2sdi SDI ( id type data) JSON . ibd2sdi ibd2sdi : o --help, -h +----------------------+---------+ | | --help | | | | +----------------------+---------+ | | Boolean | +----------------------+---------+ | | false | | | | +----------------------+---------+ . : Usage: ./ibd2sdi [-v] [-c ] [-d ] [-n] filename1 [filenames] See http://dev.mysql.com/doc/refman/9.7/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/9.7/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 Specify the strict checksum algorithm by the user. Allowed values are innodb, crc32, none. -n, --no-check Ignore the checksum verification. -p, --pretty Pretty format the SDI output.If false, SDI would be not human readable but it will be of less size (Defaults to on; use --skip-pretty to disable.) Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) -------------------------------- -------------------------------------- - debug (No default value) dump-file (No default value) skip-data FALSE id 0 type 0 strict-check crc32 no-check FALSE pretty TRUE o --version, -v +----------------------+-----------+ | | --version | | | | +----------------------+-----------+ | | Boolean | +----------------------+-----------+ | | false | | | | +----------------------+-----------+ . : ibd2sdi Ver 9.7.0 for Linux on x86_64 (Source distribution) o --debug[=debug_options], -# [debug_options] +----------------------+-----------------+ | | --debug=options | | | | +----------------------+-----------------+ | | String | +----------------------+-----------------+ | | [none] | | | | +----------------------+-----------------+ . 7.9.4 " DBUG" . ibd2sdi --debug=d:t /tmp/ibd2sdi.trace MySQL WITH_DEBUG . MySQL Oracle . o --dump-file=, -d +----------------------+------------------+ | | --dump-file=file | | | | +----------------------+------------------+ | | File name | +----------------------+------------------+ | | [none] | | | | +----------------------+------------------+ (SDI) . SDI stdout . ibd2sdi --dump-file=file_name ../data/test/t1.ibd o --skip-data, -s +----------------------+-------------+ | | --skip-data | | | | +----------------------+-------------+ | | Boolean | +----------------------+-------------+ | | false | | | | +----------------------+-------------+ data (SDI) id type SDI . $> ibd2sdi --skip-data ../data/test/t1.ibd ["ibd2sdi" , { "type": 1, "id": 330 } , { "type": 2, "id": 7 } ] o --id=#, -i # +----------------------+---------+ | | --id=# | | | | +----------------------+---------+ | | Integer | +----------------------+---------+ | | 0 | | | | +----------------------+---------+ (SDI) (object id) . . id mysql.tables mysql.tablespace . 16.1 " (Data Dictionary Schema)" . $> ibd2sdi --id=7 ../data/test/t1.ibd ["ibd2sdi" , { "type": 2, "id": 7, "object": { "mysqld_version_id": 80003, "dd_version": 80003, "sdi_version": 1, "dd_object_type": "Tablespace", "dd_object": { "name": "test/t1", "comment": "", "options": "", "se_private_data": "flags=16417;id=2;server_version=80003;space_version=1;", "engine": "InnoDB", "files": [ { "ordinal_position": 1, "filename": "./test/t1.ibd", "se_private_data": "id=2;" } ] } } } ] o --type=#, -t # +----------------------+-------------+ | | --type=# | | | | +----------------------+-------------+ | | Enumeration | +----------------------+-------------+ | | 0 | | | | +----------------------+-------------+ | | 1 2 | | | | +----------------------+-------------+ (SDI) . SDI (type=1) (type=2) . ts1 test : $> ibd2sdi --type=2 ../data/test/ts1.ibd ["ibd2sdi" , { "type": 2, "id": 7, "object": { "mysqld_version_id": 80003, "dd_version": 80003, "sdi_version": 1, "dd_object_type": "Tablespace", "dd_object": { "name": "test/ts1", "comment": "", "options": "", "se_private_data": "flags=16417;id=2;server_version=80003;space_version=1;", "engine": "InnoDB", "files": [ { "ordinal_position": 1, "filename": "./test/ts1.ibd", "se_private_data": "id=2;" } ] } } } ] InnoDB ibd2sdi DEFAULT . i : CREATE TABLE t1 (c VARCHAR(16) NOT NULL); CREATE TABLE t2 (c VARCHAR(16) NOT NULL DEFAULT "Sakila"); ibd2sdi default_value c (pad) : $> ibd2sdi ../data/i/t1.ibd | grep -m1 '\"default_value\"' | cut -b34- | sed -e s/,// "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\nAAAAAAAAAAA=" $> ibd2sdi ../data/i/t2.ibd | grep -m1 '\"default_value\"' | cut -b34- | sed -e s/,// "BlNha2lsYQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\nAAAAAAAAAAA=" ibd2sdi JSON jq[3] : $> ibd2sdi ../data/i/t1.ibd | jq '.[1]["object"]["dd_object"]["columns"][0]["default_value"]' "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\nAAAAAAAAAAA=" $> ibd2sdi ../data/i/t2.ibd | jq '.[1]["object"]["dd_object"]["columns"][0]["default_value"]' "BlNha2lsYQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\nAAAAAAAAAAA=" MySQL[4] . o --strict-check, -c +----------------------+--------------------------+ | | --strict-check=algorithm | | | | +----------------------+--------------------------+ | | Enumeration | +----------------------+--------------------------+ | | crc32 | | | | +----------------------+--------------------------+ | | crc32 innodb none | | | | +----------------------+--------------------------+ (strict checksum) . innodb crc32 none . innodb : ibd2sdi --strict-check=innodb ../data/test/t1.ibd crc32 : ibd2sdi -c crc32 ../data/test/t1.ibd --strict-check innodb crc32 none . o --no-check, -n +----------------------+------------+ | | --no-check | | | | +----------------------+------------+ | | Boolean | +----------------------+------------+ | | false | | | | +----------------------+------------+ . ibd2sdi --no-check ../data/test/t1.ibd o --pretty, -p +----------------------+----------+ | | --pretty | | | | +----------------------+----------+ | | Boolean | +----------------------+----------+ | | false | | | | +----------------------+----------+ SDI JSON (pretty print) . . SDI . --skip-pretty . ibd2sdi --skip-pretty ../data/test/t1.ibd (COPYRIGHT) (C) 1997, 2026, Oracle / . (GNU General Public License) / . . . Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA http://www.gnu.org/licenses . (NOTES) 1. (serialized dictionary information) https://dev.mysql.com/doc/refman/8.4/en/glossary.html#glos_serialized_dictionary_information 2. (system tablespace) https://dev.mysql.com/doc/refman/8.4/en/glossary.html#glos_system_tablespace 3. jq https://stedolan.github.io/jq 4. MySQL (MySQL Internals documentation) https://dev.mysql.com/doc/dev/mysql-server/latest (SEE ALSO) MySQL http://dev.mysql.com/doc . (AUTHOR) Oracle (http://dev.mysql.com). MySQL 9.7 03/24/2026 IBD2SDI(1)