you can now Backup database of your laravel app very easily using backup package for laravel 5.1 .Backup is a Laravel package that allow the creation and restoration of database backups in an easy way. so lets started with installation

Quick Installation

Begin by installing this package through Composer.

You can run:

composer require paulvl/backup 1.*

Or edit your project’s composer.json file to require paulvl/backup.

    "require-dev": {
        "paulvl/backup": "1.*"
    }

Next, update Composer from the Terminal:

composer update --dev

Once the package’s installation completes, the final step is to add the service provider. Open config/app.php, and add a new item to the providers array:

BackupBackupServiceProvider::class,

Finally publish package’s configuration file:

php artisan vendor:publish

Then the file config/backup.php will be created.

That’s it! You’re all set to go. Run the artisan command from the Terminal to see the new backup commands.

php artisan

Mysql

Creating a backup

To make a backup of you current aplicationa database you have to run:

php artisan backup:mysq-dump

This will create an .sql file on your configured path like /this/is/my/path/dbname_20150101201505.sql, this file is named using current datetime. If you want a custom name run:

php artisan backup:mysql-dump example

This will create an .sql file on your configured path like /this/is/my/path/example.sql

Restoring database from file

To restore a backup to your current aplicationa database you have to run:

php artisan mysql:restore filename

This will restore the /this/is/my/path/filename.sql file stored on your configured.

Programing backups

If you need to perform a backup for example, every day at midnight, at this like to yor schedule function on app/Console/Commands/Kernel.php:

protected function schedule(Schedule $schedule)
{
...
    $schedule->command('backup:mysql-dump')->dailyAt('00:00');
...
}



Useful links

Links
Author
Advertisements