This package is abandoned. This Backup Manager has fully replaced it.
A framework-agnostic database backup package.
Drivers: At this moment the package supports MySQL, gzip, and Amazon S3. However, it's modular and could be extended to support much more.
Frameworks: This package doesn't require a framework, but a Laravel service provider and Artisan command are made available for convenience.
Note: be aware that this package uses mysqldump for MySQL backups.
Laravel users can run the following command if they'd like to backup the db, gzip it, upload it to s3, and remove the local backup file:
php artisan db:backup --s3-bucket=whatever --s3-path=/this/is/optional/ --cleanup --gzipNon-Laravel users can look at the Usage section below.
- 5.4 (would openly accept pull requests to lower to 5.3)
-
add to composer.json
"mccool/database-backup": "1.0.1"
-
install dependency
composer update
-
install configuration file
php artisan config:publish mccool/database-backup
-
add service provider to config/app.php
'McCool\DatabaseBackup\ServiceProviders\LaravelServiceProvider', -
add key / secret to the config file in
app/config/packages/mccool/database-backup/aws.php
-
add to composer.json
"mccool/database-backup": "dev-master"
-
install dependency
composer update
-
make sure that your app requires the composer autoloader
require '../vendor/autoload.php';
Dump the database to app/storage/dumps/databasename_timestamp.sql
php artisan db:backupStore the database to backups/databasename_timestamp.sql
php artisan db:backup --local-path=backupsGzip the database.
php artisan db:backup --gzipChoose a database to dump other than the default (names are configured in Laravel's config/database.php).
php artisan db:backup --database=otherdatabaseconnectionChoose a specific filename other than the default (default is 'Y-m-d_H-i-s' ). Note, do not include the file extension .sql, we will do that for you
php artisan db:backup --filename=my_project_backupUpload the backup to S3
php artisan db:backup --s3-bucket=whatever --s3-path=/this/is/optional/Cleanup file when we're done
php artisan db:backup --s3-bucket=whatever --s3-path=/this/is/optional/ --cleanup<?php
require '../vendor/autoload.php';
// dump the database to backup/test.sql
$shellProcessor = new McCool\DatabaseBackup\Processors\ShellProcessor(new Symfony\Component\Process\Process(''));
$dumper = new McCool\DatabaseBackup\Dumpers\MysqlDumper($shellProcessor, 'localhost', 3306, 'username', 'password', 'test_db', 'backup/test.sql');
$backup = new McCool\DatabaseBackup\BackupProcedure($dumper);
$backup->backup();
// dump the database to backup/test.sql and gzip it
$shellProcessor = new McCool\DatabaseBackup\Processors\ShellProcessor(new Symfony\Component\Process\Process(''));
$dumper = new McCool\DatabaseBackup\Dumpers\MysqlDumper($shellProcessor, 'localhost', 3306, 'username', 'password', 'test_db', 'backup/test.sql');
$archiver = new McCool\DatabaseBackup\Archivers\GzipArchiver($shellProcessor);
$backup = new McCool\DatabaseBackup\BackupProcedure($dumper);
$backup->setArchiver($archiver);
$backup->backup();
// dump the database to backup/test.sql, gzip it, upload it to S3, and clean up after ourselves
$shellProcessor = new McCool\DatabaseBackup\Processors\ShellProcessor(new Symfony\Component\Process\Process(''));
$dumper = new McCool\DatabaseBackup\Dumpers\MysqlDumper($shellProcessor, 'localhost', 3306, 'username', 'password', 'test_db', 'backup/test.sql');
$archiver = new McCool\DatabaseBackup\Archivers\GzipArchiver($shellProcessor);
$storer = new McCool\DatabaseBackup\Storers\S3Storer($awsKey, $awsSecret, 'us-east-1', $bucket, $s3Path);
$backup = new McCool\DatabaseBackup\BackupProcedure($dumper);
$backup->setArchiver($archiver);
$backup->setStorer($storer);
$backup->backup();
$backup->cleanup();MIT
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent