i am working on a data collection system for an epidemiological study. the study holds among other things sensitive personal information. the personal info is stored in ONE table (i am using innodb_file_per_table) which we encrypt and wipe after the server is shutdown.
the question is, where else could this data sit on disk? since i am new to MySQL, i am trying to get clear on the log files, what they contain, which ones hold data. i gather if we want to be able to perform rollbacks, we would need to keep the log files around, and since they store SQL transactions, we would have to encrypt (and wipe) them as well after the data collection session is over and server is shut down. right now i see ib_logfile{0,1}files and an ibdata1 file in addition to our *.frm and *.ibd tables. need we encrypt the *.frm files as well? which of the ibXXX files need we encrypt? are there any other MySQL files ANYWHERE that i should be aware of? Does MySQL ever write anything to the Windows temp directories? (Windows only app) yes, i am aware of MySQL encryption on a per field basis. we were asked to encrypt the whole table. many thanks les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]