paulvl / mysql
Mysql backups fro laravel 5.1
Requires
- php: >=5.5.9
- laravel/framework: 5.1.*
This package is auto-updated.
Last update: 2024-11-12 04:47:43 UTC
README
Introduction
Quick Installation
Begin by installing this package through Composer.
You can run:
composer require paulvl/mysql
Or edit your project's composer.json file to require paulvl/json-api.
"require-dev": {
"paulvl/mysql": "^1.0"
}
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:
PaulVL\Mysql\BackupServiceProvider::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 json-api
commands.
php artisan
Creating a backup
To make a backup of you current aplicationa database you have to run:
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:
php artisan 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 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('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.