0

Suppose I have huge MySQL dump files and want to garble or remove personal information in them. What would be the best approach to doing that? Are there existing tools?

I know the database schema and can split the data into separate files without the schema, so I can actually parse them. Are there simple MySQL compatible parsers available? Would it make sense to just use regular expressions or even just some awk/sed instead?

clorz
  • 1,003
  • 2
  • 14
  • 27
  • 1
    Dump as CSV. Mangle it there. Reimport from CSV. These tools need to be built to match the schema and data you're working with. There's no one-size-fits-all solution. – tadman Feb 09 '21 at 20:40

0 Answers0