paulvl/mysql

Mysql backups fro laravel 5.1

Mysql

Introduction

Quick Installation

Begin by installing this package through Composer., _(*1)

You can run:, _(*2)

composer require paulvl/mysql

Or edit your project's composer.json file to require paulvl/json-api., _(*3)

    "require-dev": {
        "paulvl/mysql": "^1.0"
    }

Next, update Composer from the Terminal:, _(*4)

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:, _(*5)

PaulVL\Mysql\BackupServiceProvider::class,

Finally publish package's configuration file:, _(*6)

php artisan vendor:publish

Then the file config/backup.php will be created., _(*7)

That's it! You're all set to go. Run the artisan command from the Terminal to see the new json-api commands., _(*8)

php artisan

Creating a backup

To make a backup of you current aplicationa database you have to run:, _(*9)

php artisan mysql:dump

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

php artisan mysql:dump example

This will create an .sql file on your configured path like /this/is/my/path/example.sql, _(*11)

Restoring database from file

To restore a backup to your current aplicationa database you have to run:, _(*12)

php artisan mysql:restore filename

This will restore the filename.sql file stored on your configured., _(*13)

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:, _(*14)

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

Contribute and share ;-)

If you like this little piece of code share it with you friends and feel free to contribute with any improvements., _(*15)