DBRECOVER for MySQL read single .ibd file

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


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *