You can install this package via composer using:
composer require a2design-inc/laravel-db-backup
Register the provider (config/app.php) for Laravel < 5.5 or if you don't use auto-discovery:
'providers' => [
...
/*
* Package Service Providers...
*/
A2design\DbBackup\DbBackupServiceProvider::class,
...
],
For backup the database use next command
php artisan db:backup
Also you can list all existed backups (for example before restore) using next command
php artisan db:backups-list
And for restore backup use next command
php artisan db:restore
By default this command will use latest backup, but you can provide filename of existed backup
php artisan db:restore 2017-12-17.sql[.gz]
In this case using compression will be detected automatically.
The commands can, like an other command, be scheduled in Laravel's console kernel.
// app/Console/Kernel.php
protected function schedule(Schedule $schedule)
{
$schedule->command('db:backup')->daily()->at('00:00');
}
Of course, the schedules used in the code above are just an example. Adjust them to your own preferences.
Licensed under The MIT License
Developed by A2 Design Inc.