MySQL Generate Data dictionary

git clone https://github.com/twindb/undrop-for-innodb.git

Make

[Email protected] undrop- for-innodb]# MAKECC-d_file_offset_bits= --wall-g-o3-pipe-i./include-C STREAM_PARSER.CCC-d_file_offset_bits= --wall-g-O3-PIPE-I./INCLUDE-PTHREAD-LM STREAM_PARSER.O-o stream_parserflex sql_parser.lsql_parser.l: the: Warning, the character range [-Y] isAmbiguousinchA Case-insensitive SCANNERSQL_PARSER.L: the: Warning, the character range [a] isAmbiguousinchA Case-insensitive Scannerbison-o sql_parser.c sql_parser.ysql_parser.y:conflicts:6shift/REDUCECC-d_file_offset_bits= --wall-g-o3-pipe-i./include-C sql_parser.clex.yy.c:3430: Warning: ' yyunput ' defined but not usedlex.yy.c:3471: Warning: ' input ' defined but not USEDCC-d_file_offset_bits= --wall-g-o3-pipe-i./include-c c_parser.c./INCLUDE/CTYPE-LATIN1.C:359: Warning: ' my_mb_wc_latin1 ' defined but not used./INCLUDE/CTYPE-LATIN1.C:372: Warning: ' my_wc_mb_latin1 ' defined but not USEDCC-d_file_offset_bits= --wall-g-o3-pipe-i./include-C TABLES_DICT.CCC-d_file_offset_bits= --wall-g-o3-pipe-i./include-C PRINT_DATA.CCC-d_file_offset_bits= --wall-g-o3-pipe-i./include-C CHECK_DATA.CCC-d_file_offset_bits= --wall-g-o3-pipe-i./include sql_parser.o c_parser.o tables_dict.o print_data.o check_data.o-o c_parser-pthread-LMCC-d_file_offset_bits= --wall-g-o3-pipe-i./include-o Innochecksum_changer INNOCHECKSUM.C

View Code

To create a recovery database

Create Database recovery;

Extracting a data dictionary

Create database recovery;. /stream_parser-f/data/mysql//ibdata1 mkdir-p dumps/default./c_parser-6f pages-ibdata1/fil_page_index/ 0000000000000001.page-t dictionary/sys_tables.sql > Dumps/default/sys_tables 2> dumps/default/SYS_TABLES.sql. /c_parser-6f pages-ibdata1/fil_page_index/0000000000000003.page-t dictionary/sys_indexes.sql > dumps/default/ Sys_indexes 2> dumps/default/sys_indexes.sql Loading Data mysql-u root-p Recovery < dictionary/sys_tables.sql mysql-u Roo  T-p Recovery < Dictionary/sys_indexes.sql mysql-u Root-p recovery < dumps/default/sys_tables.sql mysql-u Root-p Recovery < Dumps/default/sys_indexes.sql

　　

View data information

Mysql>Select* fromSys_tableswhereName like'%tb%';+-------+----+--------+------+--------+---------+--------------+-------+| NAME | ID | N_cols | TYPE | mix_id | Mix_len | Cluster_Name | SPACE |+-------+----+--------+------+--------+---------+--------------+-------+| HT/TB | +|2| -|0| the| | at|+-------+----+--------+------+--------+---------+--------------+-------+1Rowinch Set(0.00sec) MySQL>Select* fromSys_indexeswhereTable_id= +;+----------+----+---------+----------+------+-------+---------+| table_id | ID | NAME | N_fields | TYPE | SPACE | Page_no |+----------+----+---------+----------+------+-------+---------+| +| A| PRIMARY |1|3| at|3|+----------+----+---------+----------+------+-------+---------+1Rowinch Set(0.00Sec

MySQL Generate Data dictionary