Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching, Zero-Downtime Upgrade, GoldenGate

Oracle Exadata ,Oracle ODA, Oracle ZDLRA


当前位置: 首页 » 技术文章 » MySQL

Open source Innodb recovery tool(undrop for innodb)

undrop-for-innodb是针对Innodb存储引擎的一套数据恢复工具,下面的几种情况都支持。这个工具在github上。如果想寻求商业支持,还可以放问https://twindb.com/mysql-data-recovery/
    A table or database was dropped.
    InnoDB table space corruption.
    Hard disk failure.
    File system corruption.
    Records were deleted from a table.
    A table was truncated.
    InnoDB files were accidentally deleted.
    A table was dropped and created empty one.

三个重要的工具

c_parser ,stream_parser ,sys_parser

从Makefile文件中,我们可以看到,sys_parser.c这个需要MySQL的安装路径

sys_parser: sys_parser.c
    @ which mysql_config || (echo "sys_parser needs mysql development package( either -devel or -dev)"; exit -1)
    $(CC) -o $@ $< `mysql_config --cflags` `mysql_config --libs`

如何安装和编译

[root@ohs1 ~]# git clone https://github.com/twindb/undrop-for-innodb.git

[root@ohs1 ~]# cd undrop-for-innodb
[root@ohs1 undrop-for-innodb]# make

注意:编译需要这些`make`, `gcc`, `flex` and `bison`

下面是恢复从几个场景,最下面哪个链接还中文的介绍。如果感兴趣,可以参考。


Reference

https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html

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

https://yq.aliyun.com/articles/281230

关键词:recovery innodb 

相关文章

MySQL HA - Innodb Cluster
Open source Innodb recovery tool(undrop for innodb)
InnoDB internals and structures
Top