Download the PHP package payu/mysql-dump-anonymizer without Composer
On this page you can find all versions of the php package payu/mysql-dump-anonymizer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download payu/mysql-dump-anonymizer
More information about payu/mysql-dump-anonymizer
Files in payu/mysql-dump-anonymizer
Package mysql-dump-anonymizer
Short Description Anonymizer for MySQL dumps. Can be used standalone or as a library.
License Apache-2.0
Informations about the package mysql-dump-anonymizer
Work In Progress
This library handles parsing of a mysql dump file and anonymizing it using data types and rules mysql dump must be exported using:
- --skip-add-drop-table
- --skip-add-locks
- --skip-comments
- --skip-disable-keys
- --skip-set-charset
- --compact (all 5 above)
- --complete-insert
- --hex-blob
- --extended-insert (default on)
Optional for speed:
- --quick (default on, for faster export)
- --innodb-optimize-keys (for faster import)
Optional for consistency
- --skip-lock-tables
- --single-transaction (automatically enables the above one)
- --lock-for-backup (percona specific)
Basically the command will look like:
mysqldump --complete-insert --hex-blob --innodb-optimize-keys --single-transaction --lock-for-backup <database>
and the output of it can be directly passed to anonymizer.
When using --compact dump file will not have @@SQL_MODE setting of the source server. When dealing with options like STRICT_TRANS_TABLES / NO_ZERO_IN_DATE this can be a problem.
Check the system variables net_buffer_length
and max-allowed-packet
on the
destination server to be at least the same amount as on the source server.
Or pass the sql file at input and at output:
php bin/mysql-dump-anonymize.php --config=FILENAME <databse-dump.sql >databse-dump-anonymized.sql
All versions of mysql-dump-anonymizer with dependencies
symfony/yaml Version ^5.0
ext-json Version *
myclabs/php-enum Version ^1.7.1