DBRECOVER for MySQL RECOVER CASE : DROP DATABASE

Dec 6, 2023

—

After MySQL drops database the data is still on the media for a while. So you can fetch records and rebuild database with DBRECOVER.

mysql> drop database employees;
Query OK, 14 rows affected (0.16 sec)

#sync
#sync

select drop database recovery
select MYSQL VERSION as you used; Page Size should be left as 16k
click select directory , and input the @@datadir directory

!!!caution: you should input the @@datadir directory here. pls don’t copy the @@datadir directory to any other filesystem or mount point , and use the copy one . The software need to scan the original filesystem or mount point ,otherwise it can’t work.You’d better set @datadir mount point as read only, avoid any more disk write is necessary. And don’t locate DBRECOVER software package on the same filesystem.