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?