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.
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/symfonyThis command requires you to have Composer installed globally, as explained in the installation chapter of the Composer documentation.
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.
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],
// ...
];# 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:[email protected]: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: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.sqlRestore 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 gzipThis package does not allow you to backup from one database type and restore to another. A MySQL dump is not compatible with PostgreSQL.
- PHP 7.3
- MySQL support requires
mysqldumpandmysqlcommand-line binaries - PostgreSQL support requires
pg_dumpandpsqlcommand-line binaries - Gzip support requires
gzipandgunzipcommand-line binaries
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent