Mariadb Recovery

Posted by PDSERVICE on Jul 21, 2021 In

I would like to take the software but i want to know if i have idb file it can retrieve the data? Because i tried the free version but it seems that there are some missing tables. Hope that buying it will unlock it?

no , dbrecover for mysql won't . you need to try and verify you can find your table , the only limit is how many rows you can recover.

Will it be possible to view all the databases in the recovery trash folder in your software after a dropped of dbs with the drop datasebase recobery?

Because i was able to view some it and after it is unable to have the whole tables of the db. Should i use the scenario of drop database to make it possible or is there another way of doing it?

yes , you should use the drop database mode. if you can't find a table , it indicates the drop table metadata has been purged from the ibdata1.

Then would it be a chance to get to a previous state to get it back?

if you have old ibdata1 , try to replace it with the current one , and scan again .

Otherwise have to review every page file under the software directory, recognize every table by manual .

Can you share a method to get all tables manually with the pages?

find the pages-xx directory under the software directory , review every page file in that directory using text editor software( notepad++ /sublime) , then you need to recognize them one by one( it will take long time , if you have lots of tables)

after that , follow this blog : https://www.dbrecover.com/post/dbrecover-for-mysql-read-single-ibd-file

attention : you should add page as page file ,not the ibd file(like the blog).

As there were some other databases drop in the server. How is quickly possible to view the right tables of the db dropped in the pages?

i think there is no trick . but if you know the table content , you can grep content. for example , you know the table contains info like “ABC” . then

grep "ABC" *

You are here

Mariadb Recovery

Mariadb Recovery