MySQL8.0自带工具ibd2sdi解析ibd文件

ibd文件是mysql的表数据文件，在mysql8之前数据表里的表定义放在xxx.frm文件中，表数据和表索引放在.ibd文件中。都在mysql的data目录下的数据库名所在目录下。不知道自己data目录在哪里的在数据库执行show variables like ‘%datadir%’ 查看路径
将MySQL8.0的bin路径加入系统环境变量path里（C:\Program Files\MySQL\MySQL Server 8.0\bin）

进入mysql数据文件目录C:\ProgramData\MySQL\MySQL Server 8.0\Data\test>
找到自己的表的ibd文件

在当前目录打开cmd

执行命令解析

ibd2sdi --dump-file member.txt member.ibd

查看解析后的txt文件，我们可以看到8.0版本的mysql把表结构、索引全部都放到了表数据文件ibd文件中了

["ibd2sdi",{"type":1,"id":401,"object":{"mysqld_version_id":80031,"dd_version":80023,"sdi_version":80019,"dd_object_type":"Table","dd_object":{"name":"member","mysql_version_id":80031,"created":20230110035139,"last_altered":20230110035139,"hidden":1,"options":"avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;","columns":[{"name":"id","type":4,"is_nullable":false,"is_zerofill":false,"is_unsigned":true,"is_auto_increment":true,"is_virtual":false,"hidden":1,"ordinal_position":1,"char_length":10,"numeric_precision":10,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"AAAAAA==","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"ID","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"table_id=1094;","engine_attribute":"","secondary_engine_attribute":"","column_key":2,"column_type_utf8":"int unsigned","elements":[],"collation_id":255,"is_explicit_collation":false},{"name":"username","type":16,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":2,"char_length":64,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\nAAAAAAAAAAA=","default_value_utf8_null":false,"default_value_utf8":"","default_option":"","update_option":"","comment":"账户名","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"table_id=1094;","engine_attribute":"","secondary_engine_attribute":"","column_key":1,"column_type_utf8":"varchar(16)","elements":[],"collation_id":255,"is_explicit_collation":false},{"name":"password","type":16,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":3,"char_length":96,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\nAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==","default_value_utf8_null":false,"default_value_utf8":"","default_option":"","update_option":"","comment":"密码","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"table_id=1094;","engine_attribute":"","secondary_engine_attribute":"","column_key":1,"column_type_utf8":"varchar(24)","elements":[],"collation_id":255,"is_explicit_collation":false},{"name":"createTime","type":19,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":4,"char_length":19,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":0,"has_no_default":false,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"gAAAAAA=","default_value_utf8_null":false,"default_value_utf8":"CURRENT_TIMESTAMP","default_option":"CURRENT_TIMESTAMP","update_option":"","comment":"创建时间","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"table_id=1094;","engine_attribute":"","secondary_engine_attribute":"","column_key":1,"column_type_utf8":"datetime","elements":[],"collation_id":8,"is_explicit_collation":false},{"name":"updateTime","type":19,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":1,"ordinal_position":5,"char_length":19,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":0,"has_no_default":false,"default_value_null":false,"srs_id_null":true,"srs_id":0,"default_value":"gAAAAAA=","default_value_utf8_null":false,"default_value_utf8":"CURRENT_TIMESTAMP","default_option":"CURRENT_TIMESTAMP","update_option":"CURRENT_TIMESTAMP","comment":"修改时间","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"table_id=1094;","engine_attribute":"","secondary_engine_attribute":"","column_key":1,"column_type_utf8":"datetime","elements":[],"collation_id":8,"is_explicit_collation":false},{"name":"DB_TRX_ID","type":10,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":2,"ordinal_position":6,"char_length":6,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"","se_private_data":"table_id=1094;","engine_attribute":"","secondary_engine_attribute":"","column_key":1,"column_type_utf8":"","elements":[],"collation_id":63,"is_explicit_collation":false},{"name":"DB_ROLL_PTR","type":9,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"is_virtual":false,"hidden":2,"ordinal_position":7,"char_length":7,"numeric_precision":0,"numeric_scale":0,"numeric_scale_null":true,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"","se_private_data":"table_id=1094;","engine_attribute":"","secondary_engine_attribute":"","column_key":1,"column_type_utf8":"","elements":[],"collation_id":63,"is_explicit_collation":false}],"schema_ref":"test","se_private_id":1094,"engine":"InnoDB","last_checked_for_upgrade_version_id":0,"comment":"会员","se_private_data":"autoinc=0;version=0;","engine_attribute":"","secondary_engine_attribute":"","row_format":2,"partition_type":0,"partition_expression":"","partition_expression_utf8":"","default_partitioning":0,"subpartition_type":0,"subpartition_expression":"","subpartition_expression_utf8":"","default_subpartitioning":0,"indexes":[{"name":"PRIMARY","hidden":false,"is_generated":false,"ordinal_position":1,"comment":"","options":"flags=0;","se_private_data":"id=213;root=4;space_id=32;table_id=1094;trx_id=1646;","type":1,"algorithm":2,"is_algorithm_explicit":false,"is_visible":true,"engine":"InnoDB","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":4,"order":2,"hidden":false,"column_opx":0},{"ordinal_position":2,"length":4294967295,"order":2,"hidden":true,"column_opx":5},{"ordinal_position":3,"length":4294967295,"order":2,"hidden":true,"column_opx":6},{"ordinal_position":4,"length":4294967295,"order":2,"hidden":true,"column_opx":1},{"ordinal_position":5,"length":4294967295,"order":2,"hidden":true,"column_opx":2},{"ordinal_position":6,"length":4294967295,"order":2,"hidden":true,"column_opx":3},{"ordinal_position":7,"length":4294967295,"order":2,"hidden":true,"column_opx":4}],"tablespace_ref":"test/member"}],"foreign_keys":[],"check_constraints":[],"partitions":[],"collation_id":255}}},{"type":2,"id":37,"object":{"mysqld_version_id":80031,"dd_version":80023,"sdi_version":80019,"dd_object_type":"Tablespace","dd_object":{"name":"test/member","comment":"","options":"autoextend_size=0;encryption=N;","se_private_data":"flags=16417;id=32;server_version=80031;space_version=1;state=normal;","engine":"InnoDB","engine_attribute":"","files":[{"ordinal_position":1,"filename":".\\test\\member.ibd","se_private_data":"id=32;"}]}}}]