top of page
Search

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://www.dbrecover.com/post/dbrecover-for-mysql-recover-case-frm-corrupted-or-lost-create-table-sql



















4,799 views0 comments
bottom of page