You may lost files of @datadir , but left some ibd and frm files. DBRECOVER for MySQL can directly read innodb file .ibd , and extract data.
- select add .ibd from menu start
- input the ibd file location
- right click the ibd file , scan it
- click the first page node , and input create table sql
- choose the right mysql version , and page format (dynamic in most version)
- select the Data Tab , then you can check records and export them into MYSQLDUMP format SQL file.
if you don’t have the create table sql , you can parse the frm file via dbrecover , pls reference : https://dbrecover.com/129.html
Leave a Reply