mysql – Recover accidentally formatted and deleted directory on CentOS
I accidentally mounted a new drive partition to two directories instead of one.
mount -t auto /dev/sdb2 /var/lib/mysql
mount -t auto /dev/sdb2 /var/lib/mysql_backup
After my first drive was full after I found out I did something wrong I continued my mistake by unmounting the partition and reformating and splitting the partition in two.
I lost the latest MySQL data since my backup is almost 2 weeks old. I tried to search for the lost files but unfortunately no luck. I used testdisk
on the primary drive partition /dev/sda5
and the new disk partition /dev/sdb2
to recover the deleted MySQL files however no luck I couldn’t locate or recover them.
I believe there must be a way to recover those lost MySQL files to their latest data version instead of rolling back 2 weeks ago.
Any utility other than testdisk
can help or any other suggestions. Your expertise and suggestions are highly appreciated.
Read more here: Source link