antihero/mount-last-db-bundle

Symfony bundle to mount last .gz sql dump from remote SMB server and execute it. Optional sql script (ie. to dump DB before import) and migration execution.

0.2.5 2024-02-07 17:54 UTC

Requires

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

Requires (Dev)

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

MIT

• Manu Quartier

README

Symfony bundle to mount last .gz sql dump from remote SMB or FTPS server and execute it. Optional schema drop (doctrine: schema: drop --force) and migration execution (d:m:m)

Install

composer require antihero/mount-last-db-bundle

Config

mount_last_db:
    srv_type: ftps|smb
    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: PASS
    srv_share: mysql_backups (only for smb)
    srv_workgroup: workgroup (only for smb)

php bin/console debug:config mount_last_db

Use

php bin/console ah:mount-last-db