Working with client databases

GDPR and CCPA don’t only cover the website when it’s live. They also dictate rules and guidelines that need to be followed while working with client databases.

If the client database stores any personal data it needs to be sanitized prior to being used on your local.

This Drush dumper https://github.com/robiningelbrecht/drush-gdpr-dumper is an extension of a regular Dumper. And currently this is a preferred way to obtain a sanitized Database dump for your local use.

The dumper is 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 will automatically strip all GDPR related data from the sql dump to help you be GDPR compliant.

Use this dump instead of raw DB you may get with Lando.