A drop-in replacement for drush sql-dump that optionally sanitizes DB fields for better GDPR conformity.
It is based on the machbarmacher/gdpr-dump library, and can in principle dump any database that PDO supports.
If you want to create an sql dump on live servers for local purposes (as a developer, themer, ...), you should use following command:
drush sql-dump-gdpr > file.sql
instead of
drush sql-dump > file.sql
drush sql-dump-gdpr
will automatically strip all GDPR related data from the sql dump to help you
be GDPR compliant YO!
In settings.php you can do the override configuration like this:
$config['gdpr_dumper.settings']['gdpr_replacements'] = [
'users_field_data' => [ // Table
'name' => [ // Field
'formatter' => 'userName', // Faker formatter
],
],
];
This module can be configured by editing the gdpr_dumper.settings.yml
file.
druidfi/gdpr-mysqldump contains more info about the gdpr-expressions and gdpr-replacement options.
Faker documentation lists all available formatters.
The module dispatches two events:
GdprDumperEvents::GDPR_EXPRESSIONS
GdprDumperEvents::GDPR_REPLACEMENTS
This allows developers to alter the expressions and replacements through event subscribers on run-time
Happy GDPR'ing!