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
![](https://dbrecover.com/wp-content/uploads/2023/12/image-3.png)
![](https://dbrecover.com/wp-content/uploads/2023/12/image-4.png)
![](https://dbrecover.com/wp-content/uploads/2023/12/image-5.png)
![](https://dbrecover.com/wp-content/uploads/2023/12/image-6.png)
Leave a Reply