mysql ibd 数据文件恢复极速恢复
最近不少朋友遇到mysql 丢失ibddata 数据文件或者文件系统损坏只有部分ibd 文件的故障找我来帮忙处理,有些朋友的环境有几百上千个ibd 文件,手动恢复着实麻烦,写了一个工具,批量恢复mysql innodb,(myasim) ibd 的工具,目前可以在windows 和linux运行;mysql 的文件解析还是有点累的,搞得有点想吐
ibd recover frm recover, innodb ibd recover
###运行如下:
D:\python-project\venv\Scripts\python.exe D:/python-project/workspace/innodb_idb_recovery/recover-tool.py config.int
* MySQL InnoDB Ibd Restore tool by huanglinjie for 5.6/5.7 .
* Copyright (c) 2020, 2099, lixora. All rights reserved .
* Any problems pls connect : 17!7#6715#1782 +_+ .
************* !!! For MySQL Internal Use only !!! ***************
all mysql innodb ibd need recover frmfile_name : ['aaaa.frm', 't.frm', 't1.frm']
data_dir: /home/msb_5_6_42/data/
(1007, "Can't create database 'test'; database exists")
2020-04-26 10:38:36 ****** destPlugDB is created : test
2020-04-26 10:38:36 ****** recover tablename : aaaa
2020-04-26 10:38:36 ****** frm_path : C:\Users\Administrator\Desktop\aaaa.frm