Skip to content

How to dump database with gdpr dump

Vladyslav Shcherbyna edited this page Mar 6, 2019 · 1 revision

Changes in this repository introduce new functionality to mysqldump - ability to sanitize data. new optional arguments --gdpr added.

Exmaple of argument:

 --gdpr=magento_sales_order_grid_archive.customer_name:lastname

Where magento_sales_order_grid_archive is a table name, customer_name is a field name and word after : is a function lastname

You can add up to 256 arguments. It is considered to utilize configuration in future.

Supported functions:

lastname - replace value with next pattern Doe%lu where %lu is row number.

name - replace value with next pattern John%lu where %lu is row number.

incr - replace value with next pattern incr%lu where %lu is row number.

ip - replace value with next pattern 127.0.0.1.

phone - replace value with next pattern 5555555555.

email - replace value with next pattern m2x%[email protected] where %lu is row number.

dob - replace value with next pattern 1973-12-15 where %lu is row number.

Clone this wiki locally