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