A parser for innodb file format

中文READMD

pyinnodb.sh is a tool for dump ddl and data from ibd file, which support mysql5.7 and mysql8.0+, require py3.8+

Download

$ wget https://github.com/WinChua/pyinnodb/releases/latest/download/pyinnodb.sh
$ chmod a+x pyinnodb.sh
$ ./pyinnodb.sh --help

Usage

Mysql 8.0+

dump the ddl from ibd file

./pyinnodb.sh ${your_ibd_path} tosql --mode ddl

dump sql script to insert data

./pyinnodb.sh ${your_ibd_path} tosql --mode sql

search data with primary key(only support for int primary key now)

./pyinnodb.sh ${your_ibd_path} search --primary-key 42

Mysql 5.7

view data in ibd file, require .frm as well

./pyinnodb.sh ${your_ibd_path} frm ${your_frm_path}