SQL Dump settings

To use the SQL Dump feature, you have to first install the module named General Data Protection Regulation (GDPR) - Obfuscated SQL Dump by running the below command in your CLI, or you can directly enable the module via extend through the administrator toolbar.

                            drush en gdpr_dump -y

Apply anonymisation for each table columns containing sensitive data.

By default below listed tables are available for anonymization and by expanding More Tables you can enable other tables of your database as per requirement.

All below tables list down their fields where you can apply the anonymization. There are few available anonymizer plugins which is somehow helpful.

List of Anonymizer Plugins:

1. Date: functionality intended to be used for datetime fields.
2. URI: functionality for uri's
3. Random Text: functionality intended to be used for text fields.
4. Email: functionality intended to be used for emails.
5. Long Text: functionality intended to be used for longer text.
6. Username: functionality intended to be used for user names.
7. Text: functionality intended to be used for titles or short text.
8. Clear: functionality intended to clear data.
9. Password: functionality intended to be used for passwords.
10. Number: functionality intended to be used for numbers.

• TABLE: COMMENT__COMMENT_BODY

• TABLE: COMMENT_FIELD_DATA

• TABLE: USER__ROLES

• TABLE: USER__USER_PICTURE

• TABLE: USERS_DATA

• TABLE: USERS_FIELD_DATA

​​​​​​​

• More Tables

​​​​​​​