sidus/database-maintenance-bundle

Simple database maintenance with Doctrine and MySQL

v2.0.0 2021-02-24 05:01 UTC

Requires

• php: >=7.2
• doctrine/doctrine-bundle: >=1.6
• doctrine/orm: >=2.5
• symfony/console: >=4.0

MIT

• Vincent Chalnot

• database
• mysql
• doctrine
• maintenance

README

This bundle allows you to execute mysql and mysqldump commands without passing any authentication parameters, il will automatically uses the one declared in doctrine.

Dumping local database:

$ bin/console sidus:database:mysqldump > dump.sql

Dumping remote database to local file:

$ ssh username@host "/path/to/symfony/bin/console sidus:database:mysqldump" > dump.sql

Copying remote database to local:

$ ssh username@host "/path/to/symfony/bin/console sidus:database:mysqldump" | bin/console sidus:database:mysql

Copying local database to remote:

$ bin/console sidus:database:mysqldump | ssh username@host "/path/to/symfony/bin/console sidus:database:mysql"