antihero/mount-last-db-bundle

Symfony bundle to mount last .gz sql dump from remote SMB/SFTP server. Commands to dump or mount current DB, and to copy current DB to test DB.

0.7 2025-04-29 19:21 UTC

Requires

• php: >=8.1
• ext-ftp: *
• ext-mysqli: *
• ext-pdo: *
• ext-zlib: *
• doctrine/doctrine-bundle: 2.*
• doctrine/orm: ^2.16|^3
• symfony/config: ^5.4|6.*|7.*
• symfony/console: ^5.4|6.*|7.*
• symfony/dependency-injection: ^5.4|6.*|7.*
• symfony/dotenv: ^5.4|6.*|7.*
• symfony/framework-bundle: ^5.4|6.*|7.*
• symfony/http-client: ^5.4|6.*|7.*
• symfony/http-kernel: ^5.4|6.*|7.*
• symfony/process: ^5.4|6.*|7.*

Requires (Dev)

• phpstan/phpstan: ^1.10
• symfony/flex: ^2.3

MIT

• Manuel Quartier

README

Symfony bundle to:

• mount last .gz sql dump from remote FTPS server and execute it. Optional schema drop (doctrine: schema: drop --force) and migration execution (d:m:m)
• dump or mount local database

  Install

composer require antihero/mount-last-db-bundle

Config

mount_last_db:
    dest_dir: _dump (relative to project root)
    file_filter: lhyo_ocf
    srv_uri: 192.168.0.92
    srv_path: backups
    srv_user: USER
    srv_pwd: '%env(AH_SRV_PWD)%'
    srv_share: mysql_backups (only for smb)
    srv_workgroup: workgroup (only for smb)
    db_host: '%env(DB_HOST)%'
    db_port: '%env(DB_PORT)%'
    db_user: '%env(DB_USERNAME)%'
    db_pwd: '%env(DB_PASSWORD)%'

php bin/console debug:config mount_last_db

Usage

php bin/console ah:mount-last-db
php bin/console ah:mount-db
php bin/console ah:dump-db