Artisan command for backup Laravel application database

Installation

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,
    ...
],

Usage

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.

Scheduling

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.

License

Licensed under The MIT License

Developed by A2 Design Inc.