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



















1,899 views0 comments

Recent Posts

See All

dbrecover for mysql recover case drop database https://youtu.be/ao7OY8IbZQE dbrecover for mysql recover case crash instance https://youtu.be/DAyWq7-CR5s dbrecover for mysq

Post: Blog2_Post
bottom of page