MySQL Super Dump

Sat, Aug 10, 2013

The following text is fiction based on a true story, but it can happen with lots of development teams over the world: Once upon a time there was a development team that liked to use dumps from the production database in their development environments to have the same content and behavior of the production system in their machines. To avoid security problems, the system administrator created a script to dump the production database, import in a temporary database, then replace all sensitive data, like salts, passwords, customer names, emails, etc, for fake data, then export a dump of this temporary database to a file that is the dump developers would use.