I am running into an issue where sensitive data was not encrypted properly at the application level of our production system.
Even though the guilty records have been removed or corrected, scanning still reveal the records in the .ibd file, as well as the ibdata1 and ib_logfiles.
I have optimized the affected table and so the .ibd file is clean now; but I still have the issue of the ibdata1 and log files.
Doing a full mysqldump of all databases is a last resort as the data set if quite large. Since we are already using per table tablespaces, can I simply stop mysql, move the ib files and then restart and reset the files in that manner?