backup-manager / symfony
A simple database backup manager for Symfony2 with support for S3, Rackspace, Dropbox, FTP, SFTP.
Installs: 264 980
Dependents: 4
Suggesters: 1
Security: 0
Stars: 119
Watchers: 8
Forks: 40
Open Issues: 6
Type:symfony-bundle
Requires
- php: ^7.3 || ^8.0
- backup-manager/backup-manager: ^3.0
- nyholm/dsn: ^2.0
- symfony/config: ^3.4 || ^4.4 || ^5.0
- symfony/console: ^3.4 || ^4.4 || ^5.0
- symfony/dependency-injection: ^3.4 || ^4.4 || ^5.0
- symfony/filesystem: ^3.4 || ^4.4 || ^5.0
- symfony/framework-bundle: ^3.4 || ^4.4 || ^5.0
- symfony/http-kernel: ^3.4 || ^4.4 || ^5.0
- symfony/yaml: ^3.4 || ^4.4 || ^5.0
Requires (Dev)
Suggests
- league/flysystem-aws-s3-v3: To use AWS S3, version 3
- league/flysystem-rackspace: To use Rackspace
- league/flysystem-sftp: To use sftp
- mhetreramesh/flysystem-backblaze: To use B2
- srmklive/flysystem-dropbox-v2: To use Dropbox
- superbalist/flysystem-google-storage: Google Cloud Storage adapter support.
README
A simple database backup manager for Symfony with support for S3, Rackspace, Dropbox, FTP, SFTP.
This package pulls in the framework agnostic Backup Manager and provides seamless integration with Symfony.
Installation
Step 1: Download the Bundle
Open a command console, enter your project directory and execute the following command to download the latest stable version of this bundle:
$ composer require backup-manager/symfony
This command requires you to have Composer installed globally, as explained in the installation chapter of the Composer documentation.
Step 2 (with Flex): Enable the Bundle
You do not need to do anything more. The bundle is enabled automatically and
you have some nice default config in config/packages/bm_backup_manager.yml
.
Step 2 (no Flex): Enable the Bundle
If you are not using Symfony Flex, you need to enable the bundle by adding it to
the list of registered bundles in the app/AppKernel.php
file of your project.
// config/bundles.php return [ BM\BackupManagerBundle\BMBackupManagerBundle::class => ['all' => true], // ... ];
Step 3: Configure your databases and filesystems
# config/packages/bm_backup_manager.yml bm_backup_manager: database: development: type: mysql host: localhost port: 3306 user: root pass: password database: test ignoreTables: ['foo', 'bar'] # If DSN is specified, it will override other values dsn: 'mysql://root:root_pass@127.0.0.1:3306/test_db' production: type: postgresql host: localhost port: 5432 user: postgres pass: password database: test # You could also use a environment variable dsn: '%env(resolve:DATABASE_URL)%' storage: local: type: Local root: /path/to/working/directory s3: type: AwsS3 key: secret: region: us-east-1 version: latest bucket: root: b2: type: B2 key: accountId: bucket: rackspace: type: Rackspace username: password: container: dropbox: type: DropboxV2 token: key: secret: app: root: ftp: type: Ftp host: username: password: root: port: 21 passive: true ssl: true timeout: 30 sftp: type: Sftp host: username: password: root: port: 21 timeout: 10 privateKey:
Usage
To backup from any configured database.
Backup the development database to Amazon S3
. The S3 backup path will be test/backup.sql.gz
in the end, when gzip
is done with it.
class Foo { private $backupManager; public function __construct(BackupManager $backupManager) { $this->backupManager = $backupManager; } public function bar() { $this->backupManager->makeBackup()->run('development', [new Destination('s3', 'test/backup.sql')], 'gzip'); } }
Or with a command:
php bin/console backup-manager:backup development s3 -c gzip --filename test/backup.sql
To restore from any configured filesystem.
Restore the database file test/backup.sql.gz
from Amazon S3
to the development
database.
class Foo { private $backupManager; public function __construct(BackupManager $backupManager) { $this->backupManager = $backupManager; } public function bar() { $this->backupManager->makeRestore()->run('s3', 'test/backup.sql.gz', 'development', 'gzip'); } }
Or with a command:
php bin/console backup-manager:restore development s3 test/backup.sql.gz -c gzip
This package does not allow you to backup from one database type and restore to another. A MySQL dump is not compatible with PostgreSQL.
Requirements
- PHP 7.3
- MySQL support requires
mysqldump
andmysql
command-line binaries - PostgreSQL support requires
pg_dump
andpsql
command-line binaries - Gzip support requires
gzip
andgunzip
command-line binaries