mysql data masking

Question

Hi I'd like to a take a production database and use it in a private, development environment. But, I'd like to anonymize the data.

I've been searching for an hour, but everything I find is for Oracle or SQL Server... nothing for mysql.

I have approximately 15 tables with 75 fields that should be anonymized.

Has anybody found a recommended solution(s)?

score 8 · Answer 1 · answered Jul 14 '11 at 12:32

8

You can anonymize all entries in a MySQL table simply with

UPDATE users SET email = concat('user_', id, '@example.com');

i.e. by using an SQL Update with string expressions. The user with ID 1 gets the email user_1@example.com, the user with ID 10 gets user_10@example.com, etc.

answered Jul 14 '11 at 12:32

0x4a6f4672

27,297
17
103
140

1

Coolest answer I've seen all day – Won Jun Bae Sep 02 '15 at 22:12
This affect to production DB ,that's not what I want , is there any way to mask only dumped sql? – Bawantha Sep 02 '21 at 06:57

score 0 · Answer 2 · edited Jul 07 '20 at 15:05

0

I understand from Gartner that Camouflage data masking supports mysql and has a free downloadable version.

Check out - http://www.datamasking.com/products/featured-product-downloads

edited Jul 07 '20 at 15:05

kamaci

72,915
69
228
366

answered Feb 21 '11 at 12:17

Adrienne Mennell

1

mysql data masking

2 Answers2