Database Maintenance with Doctrine & MySQL
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.sqlDumping remote database to local file:
$ ssh username@host "/path/to/symfony/bin/console sidus:database:mysqldump" > dump.sqlCopying remote database to local:
$ ssh username@host "/path/to/symfony/bin/console sidus:database:mysqldump" | bin/console sidus:database:mysqlCopying local database to remote:
$ bin/console sidus:database:mysqldump | ssh username@host "/path/to/symfony/bin/console sidus:database:mysql"