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