即时匿名的MySQL转储

Question

I am using mysqldump to create DB dumps of the live application to be used by developers.

This data contains customer data. I want to anonymize this data, i.e. remove customer names / credit card data.

An option would be:

• create copy of database (create dump and import dump)
• fire SQL queries that anonymize the data
• dump the new database

But this has to much overhead. A better solution would be, to do the anonymization during dump creation.

I guess I would end up parsing all the mysqlsqldump output? Are there any smarter solutions?

Answer 1

You could do a select of each table (and not a select *) and specify the columns you want to have and omit or blank those you don't want to have, and then use the export option of phpmyadmin for each query.