I am running Mysql5 on a Windows Xp machine on NTFS . I want to permanently delete a database containing sensitive data such that when the operating system is not active it is not possible to use raw disk editors and recovery tools to view and recover data that the operating system has deallocated(after dropping tables etc). How can I do this ?
Asked
Active
Viewed 1,658 times
2 Answers
0
The only solution I know of is to overwrite all free space on the disk after the deletion.
Repeatedly copying small files till the disk is full, then deleting them would work.
As would have a script output '1' until the drive is full.
warren
- 10,322
0
You can use SDelete, a free tool from Microsoft. This can either securely delete a file or cleanse all the free space on a partition.
If you want a GUI, Eraser is an alternative.
Judging from the MySQL documentation for InnoDB and MyISAM, the relevant files to delete are ibdata, *.IBD, and *.FRM for an InnoDB database, and the *.FRM, *.MYD, and *.MYI files for MyISAM.
Stephen Jennings
- 23,491