Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to delete a set of MySQL tables for a client in a manner that's compliant with the Department of Defense Data Clearing and Sanitizing Standard. I've a list of acceptable tools including wipe, but I'm not clear on how I might be able to drop a MySQL table in such a manner.

Is there a way to tell MySQL to drop the table without deleting the physical files on disk, so I can securely overwrite them manually?

share|improve this question
    
Which standard? –  Michael Hampton Jan 21 '13 at 17:58
    
@MichaelHampton The link provided to me goes to a 404. I do know that they require a three-pass overwrite, and it mentions 5220.22-M. –  ceejayoz Jan 21 '13 at 18:04
add comment

1 Answer

I don't believe there is any way to securely delete a table in MySQL, or to delete it without removing the file.

There are a few options I can think of though:

  • Export the database into a new one (without the tables you want to delete), switch whatever accesses the database to use the new one, then wipe the old one
  • Delete the table, then wipe the free space on the drive
  • Stop MySQL, wipe the files for the table you want to delete, restart mysql, check/repair the database

Disclaimer: I have not tested any of these methods - use at your own risk and make sure your backups are good.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.