Bundle configuration ​

The DbToolsBundle let you configure some of its behaviours. As with any classic Symfony Bundle, all will take place in the config/packages/db_tools.yaml file.

Backup configuration ​

Some options are available to customize how the db-tools:backup command works.

Storage directory ​

The storage_directory parameter let you choose where to put the generated dumps

Default value is '%kernel.project_dir%/var/private/db_tools'.

Excluded tables ​

The excluded_tables parameter let you configure tables to exclude from backups. You will need to give a configuration per doctrine connection.

Default value is null: no table are excluded.

Here is an example for exclude table1 and table2 for the default doctrine connection:

# config/packages/db_tools.yaml

db_tools:

    #...

    excluded_tables:
        - default: ['table1', 'table2']

    #...

Backup expiration age ​

The backup_expiration_age parameter let you choose when a backup is considered as obsolete.

Default value is '3 months ago'.

Use PHP relative date/time formats for this value.

# config/packages/db_tools.yaml

db_tools:

    #...

    backup_expiration_age: '1 week ago'

    #...

Binaries ​

db-tools:backup and db-tools:restore need your system/environment to provide some extra binaries to be able to work. These binaries depend on the database vendor you use, you will need:

• for MariaDB: mariadb-dump and mariadb
• for MySQL: mysqldump and mysql
• for PostgreSQL: pg_dump and pg_restore
• for SQLite: sqlite3

You can verify that binaries for your DBAL connection(s) are correctly found by the DbToolsBundle launching:

php console db-tools:check

If the db-tools:check command returns you some errors:

• if your binaries are present on your system but the DbToolsBundle can't find them: you will need to specify path for these binaries:

# config/packages/db_tools.yaml

db_tools:

    #...

    # Specify here paths to binaries, only if the system can't find them by himself
    # platform are 'mysql', 'postgresql', 'sqlite'
    backupper_binaries:
        mariadb: '/usr/bin/mariadb-dump' # default 'mariadb-dump'
        mysql: '/usr/bin/mysqldump' # default 'mysqldump'
        postgresql: '/usr/bin/pg_dump' # default 'pg_dump'
        sqlite: '/usr/bin/sqlite3' # default 'sqlite3'
    restorer_binaries:
        mariadb: '/usr/bin/mariadb' # default 'mariadb'
        mysql: '/usr/bin/mysql' # default 'mysql'
        postgresql: '/usr/bin/pg_restore' # default 'pg_restore'
        sqlite: '/usr/bin/sqlite3' # default 'sqlite3'

    #...

• Or, if your binaries are not present on your system: you will need to install them

RUN apt-get update && \
    apt-get install -y --no-install-recommends postgresql-client

RUN apt-get update && \
    apt-get install -y --no-install-recommends default-mysql-client

Anonymizer paths ​

By default, the DbToolsBundle will look for anonymizers in 2 directories

• %kernel.project_dir%/vendor/makinacorpus/db-tools-bundle/src/Anonymizer
• %kernel.project_dir%/src/Anonymizer

If you want to put custom anonymizers in another directory or if you want to load a pack of anonymizers from en external library, you can modify/add paths:

# config/packages/db_tools.yaml

 anonymizer_paths:
        - '%kernel.project_dir%/vendor/makinacorpus/db-tools-bundle/src/Anonymization/Anonymizer'
        - '%kernel.project_dir%/src/Anonymizer'
        - '%kernel.project_dir%/vendor/myAnonymizerProvider/anonymizers/src'

Anonymization ​

Per default, the DbToolsBundle will only look for anonymization configurations from PHP attributes on Doctrine Entities.

But the DbToolsBundle does not necessary need Doctrine ORM to anonymize your data, it can do it just with a DBAL connection. In this case (or if your prefere YAML over attributes): you can configure the DbToolsBundle to look for anonymization configurations in a YAML file:

# config/packages/db_tools.yaml

db_tools:
    # ...

    # Anonymization configuration.
    anonymization:
        # If you want to load configuration from a yaml:
        # 1/ If you want to configure anonymization only for the default
        # DBAL connection, declare it like this:
        yaml: '%kernel.project_dir%/config/anonymizations.yaml'
        # 2/ If you use multiple connection, declare each configuration like this:
        #yaml:
            #- connection_one: '%kernel.project_dir%/config/anonymizations/connection_one.yaml'
            #- connection_two: '%kernel.project_dir%/config/anonymizations/connection_two.yaml'

  #...