smile / gdpr-dump
A utility to create anonymized database dumps
Installs: 16 325
Dependents: 1
Suggesters: 0
Security: 0
Stars: 181
Watchers: 14
Forks: 47
Open Issues: 3
Requires
- php: ^8.1
- composer-runtime-api: ^2.0
- ext-json: *
- ext-pdo: *
- doctrine/dbal: ^3.1
- druidfi/mysqldump-php: ^1.1
- fakerphp/faker: ^1.17
- justinrainbow/json-schema: ^5.2
- symfony/config: ^6.1
- symfony/console: ^6.1
- symfony/dependency-injection: ^6.1
- symfony/event-dispatcher: ^6.1
- symfony/finder: ^6.1
- symfony/yaml: ^6.1
- theseer/tokenizer: ^1.2
Requires (Dev)
- php-parallel-lint/php-parallel-lint: ^1.3
- phpstan/phpstan: ^1.10
- phpstan/phpstan-phpunit: ^1.3
- phpunit/phpunit: ^10.5
- slevomat/coding-standard: ^8.14
- squizlabs/php_codesniffer: ^3.7
This package is auto-updated.
Last update: 2024-10-17 11:30:56 UTC
README
This tool provides a command that dumps the contents of a MySQL database.
It is the equivalent of mysqldump, with additional features, at the cost of performance (PHP implementation). The main purpose of this tool is to create anonymized dumps, in order to comply with GDPR regulations.
Features:
- Data converters (transform the data before it is dumped to the file).
- Recursive table filtering.
- Tables whitelist (only these tables will be included in the dump).
- Tables blacklist (not included in the dump).
- Dump options (compression, output type...).
- Predefined configuration templates (Magento, Drupal, OroCommerce).
Documentation
The documentation (including installation instructions) is available in the wiki.
Community Templates
While it is not the aim of this project to cover each framework, you are encouraged to publish your templates on GitHub under the topic smile-sa-gdpr-dump-template.
FAQ
Why don't you use Doctrine to generate the dump?
The goal of Doctrine is to support a wide array of DBMS. It does not support features that are specific to some databases.
For example, in MySQL, it is possible to create an index on BLOB columns. There is a restriction though, you need to specify the length of the index.
This feature is used in Magento 2. Since Doctrine does not support this feature, it cannot be used to create a working dump file of a Magento 2 database. The following error would trigger during the import of the generated dump file:
ERROR 1170 (42000) at line 254: BLOB/TEXT column 'code' used in key specification without a key length
Also, the schema manager of Doctrine can only manage tables. It does not handle triggers, procedures, views...
As a consequence, we don't use Doctrine to generate the dump file. The dump file is generated with MySQLDump-PHP instead, which is only compatible with MySQL.
Contributing
You can contribute to this module by submitting issues or pull requests.
For more details, please take a look at the contribution guidelines.
License
This project is licensed under the GPLv3 License.
Changelog
All notable changes are recorded in this changelog.
Contact
Smile Technical Direction dirtech@smile.fr