custom database export

CLI to download databases with separated configuration for structure and data, to exclude tables, limit data and/or replace special values in the export. Specialized in export databases to fit the rules of GDPR and keep the filesize small. Less storage, less energy :)

lochmueller
6
0
PHP

Custom Database Export

CLI to download databases with separated configuration for structure and data, to exclude tables, limit data and/or replace special values in the export.
Specialized in export databases to fit the rules of GDPR and keep the filesize small. Less storage, less energy 😃

Installation

  1. Download the latest released phar file of “Custom Database Export”
  2. chmod +x custom-database-export.phar and (optional) create a alias for the execution (e.g. if you need a special PHP version)
  3. Run custom-database-export init to create the configuration file incl. the documentation
  4. Adapt the configuration for your needs
  5. Export the database with custom-database-export (optional --configuration argument for the configuration file path - default: custom-database-export.yaml)

Configuration

Check custom-database-export.yaml after the init process. The base file is a copy of this yaml.

Tech-Talk

Use druidfi/mysqldump-php for export the information and symfony yaml & console component for configuration and CLI management. Override value information with Faker (only en_US locale is part of the phar file) and pack the phar with humbug/box.

Feel free to send contributions via GitHub.