can 'Percona MySQL Data Recovery' be used to recover dropped tables if the datadir filesystem is mounted as /
- by Tom Geee
according to Percona:
Unmount the filesystem or make it read-only if...
You have filesystem corruption OR
You have dropped tables in innodb_file_per_table format
If I have innodb_file_per_table enabled, and accidently dropped a table, while the datadir is mounted as within the / partition , can data still be recovered?
Obviously you can't work with an unmounted root filesystem.
Our VPS host has a defaulted filesystem table which we cannot customize.
I was wondering in case of any future scenario.
edit:
would mounting the / filesystem through NFS onto another system as read-only be a workaround?
TIA.