district09 / backup-manager
A framework agnostic database backup manager with user-definable procedures and support for S3, Dropbox, FTP, SFTP, and more with drivers for popular frameworks.
Installs: 3 640
Dependents: 1
Suggesters: 0
Security: 0
Stars: 1
Watchers: 0
Forks: 220
Open Issues: 0
Requires
- php: >=8.0
- league/flysystem: ^2.1.1 || ^3.0
- symfony/process: ^4.4 || ^5.4 || ^6.0 || ^7.0
Requires (Dev)
- league/flysystem-async-aws-s3: ^2.0.6 || ^3.0
- league/flysystem-aws-s3-v3: ^2.0 || ^3.0
- league/flysystem-ftp: ^2.4 || ^3.0
- league/flysystem-google-cloud-storage: ^2.0 || ^3.0
- league/flysystem-sftp-v3: ^2.0 || ^3.0
- league/flysystem-webdav: ^3.0
- marcandreappel/flysystem-backblaze: ^2.1
- phpspec/phpspec: ^7.2
- spatie/flysystem-dropbox: ^2.0 || ^3.0
Suggests
- league/flysystem-aws-s3-v3: AWS S3 adapter support.
- league/flysystem-google-cloud-storage: Google Cloud Storage adapter support.
- league/flysystem-sftp: SFTP adapter support.
- league/flysystem-webdav: Webdav adapter support.
- marcandreappel/flysystem-backblaze: B2 adapter support.
- spatie/flysystem-dropbox: Dropbox API v2 adapter support.
This package is auto-updated.
Last update: 2024-10-28 11:59:08 UTC
README
This package provides a framework-agnostic database backup manager for dumping to and restoring databases from S3, Dropbox, FTP, SFTP, and Rackspace Cloud.
- use version 2+ for >=PHP 7.3
- use version 1 for <PHP 7.2
Watch a video tour showing the Laravel driver in action to give you an idea what is possible.
- supports
MySQL
andPostgreSQL
- compress with
Gzip
- framework-agnostic
- dead simple configuration
- Laravel Driver
- Symfony Driver
Table of Contents
Quick and Dirty
Configure your databases.
// config/database.php 'development' => [ 'type' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'user' => 'root', 'pass' => 'password', 'database' => 'test', // If singleTransaction is set to true, the --single-transcation flag will be set. // This is useful on transactional databases like InnoDB. // http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_single-transaction 'singleTransaction' => false, // Do not dump the given tables // Set only table names, without database name // Example: ['table1', 'table2'] // http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_ignore-table 'ignoreTables' => [], // using ssl to connect to your database - active ssl-support (mysql only): 'ssl'=>false, // add additional options to dump-command (like '--max-allowed-packet') 'extraParams'=>null, ], 'production' => [ 'type' => 'postgresql', 'host' => 'localhost', 'port' => '5432', 'user' => 'postgres', 'pass' => 'password', 'database' => 'test', ],
Configure your filesystems.
// config/storage.php 'local' => [ 'type' => 'Local', 'root' => '/path/to/working/directory', ], 's3' => [ 'type' => 'AwsS3', 'key' => '', 'secret' => '', 'region' => 'us-east-1', 'version' => 'latest', 'bucket' => '', 'root' => '', 'use_path_style_endpoint' => false, ], 'b2' => [ 'type' => 'B2', 'key' => '', 'accountId' => '', 'bucket' => '', ], 'gcs' => [ 'type' => 'Gcs', 'key' => '', 'secret' => '', 'version' => 'latest', 'bucket' => '', 'root' => '', ], 'rackspace' => [ 'type' => 'Rackspace', 'username' => '', 'key' => '', 'container' => '', 'zone' => '', 'root' => '', ], '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' => '', ], 'flysystem' => [ 'type' => 'Flysystem', 'name' => 's3_backup', //'prefix' => 'upload', ], 'doSpaces' => [ 'type' => 'AwsS3', 'key' => '', 'secret' => '', 'region' => '', 'bucket' => '', 'root' => '', 'endpoint' => '', 'use_path_style_endpoint' => false, ], 'webdav' => [ 'type' => 'Webdav', 'baseUri' => 'http://myserver.com', 'userName' => '', 'password' => '', 'prefix' => '', ],
Backup to / restore 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.
use District09\BackupManager\Filesystems\Destination; $manager = require 'bootstrap.php'; $manager->makeBackup()->run('development', [new Destination('s3', 'test/backup.sql')], 'gzip');
Backup to / restore from any configured filesystem.
Restore the database file test/backup.sql.gz
from Amazon S3
to the development
database.
$manager = require 'bootstrap.php'; $manager->makeRestore()->run('s3', 'test/backup.sql.gz', 'development', '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 5.5
- 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
Installation
Composer
Run the following to include this via Composer
composer require backup-manager/backup-manager
Then, you'll need to select the appropriate packages for the adapters that you want to use.
# to support s3 composer require league/flysystem-aws-s3-v3 # to support b2 composer require mhetreramesh/flysystem-backblaze # to support google cs composer require league/flysystem-aws-s3-v2 # to install the preferred dropbox v2 driver composer required spatie/flysystem-dropbox # to install legacy dropbox v2 driver composer require srmklive/flysystem-dropbox-v2 # to support rackspace composer require league/flysystem-rackspace # to support sftp composer require league/flysystem-sftp # to support webdav (supported by owncloud nad many other) composer require league/flysystem-webdav
Usage
Once installed, the package must be bootstrapped (initial configuration) before it can be used.
We've provided a native PHP example here.
The required bootstrapping can be found in the example here.
Contribution Guidelines
We recommend using the vagrant configuration supplied with this package for development and contribution. Simply install VirtualBox, Vagrant, and Ansible then run vagrant up
in the root folder. A virtualmachine specifically designed for development of the package will be built and launched for you.
When contributing please consider the following guidelines:
- Code style is PSR-2
- Interfaces should NOT be suffixed with
Interface
, Traits should NOT be suffixed withTrait
.
- Interfaces should NOT be suffixed with
- All methods and classes must contain docblocks.
- Ensure that you submit tests that have minimal 100% coverage. Given the project's simplicity it just makes sense.
- When planning a pull-request to add new functionality, it may be wise to submit a proposal to ensure compatibility with the project's goals.
Maintainers
This package is maintained by Shawn McCool and you!
Backwards Compatibility Breaks
3.0
Remove support for symfony 2. Specifically symfony/process versions < 3.x
License
This package is licensed under the MIT license. Go wild.