Download the PHP package freedfelipe/backup_by_table without Composer
On this page you can find all versions of the php package freedfelipe/backup_by_table. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download freedfelipe/backup_by_table
More information about freedfelipe/backup_by_table
Files in freedfelipe/backup_by_table
Package backup_by_table
Short Description Database backup by table package for laravel 5.*
License MIT
Informations about the package backup_by_table
Backup
Backup is a Laravel package that allow the creation and restoration of database backups in an easy way.
New version 3. replaces older versions and works with laravel 5.
Quick Installation
Begin by installing this package through Composer.
You can run:
composer require freedfelipe/backup 3.*
Or edit your project's composer.json file to require paulvl/backup.
Next, update Composer from the Terminal:
composer update
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:
Finally publish package's configuration file:
php artisan vendor:publish --provider="Backup\BackupServiceProvider" --tag="config"
Then the file config/backup.php
will be created.
That's it! You're ready to go. Run the artisan command from the Terminal to see the new backup
commands.
php artisan
Mysql commands
mysql-dump - Creating a backup
To make a backup of you current aplication's database you have to run:
php artisan backup:mysql-dump
This will create an .sql
file on your configured local-storage.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 custom_name
This will create an .sql
file on your configured local-storage.path
like /this/is/my/path/custom_name.sql
--compress - Enable file compression
Enable file compression regardless if is disabled in the configuration file. This option will always overwrite --no-compress
option
php artisan backup:mysql-dump --compress
--no-compress - Disable file compression
Disable file compression regardless if is enabled in the configuration file. This option will be always overwrited by --compress
option
php artisan backup:mysql-dump --no-compress
mysql-restore - Restoring database from a file
To restore a backup to your current aplication's database you have to run:
php artisan mysql:restore filename
This will display a list of your current backup files stored on your configured local-storage.disk
.
--filename | -f - Especifiy a backup file name
Especifiy a backup file name
php artisan backup:mysql-restore --filename=backup_filename
--all-backup-files | -A - Display all backup files
Display all available backup files on disk. By default displays files for current connection's database.
php artisan backup:mysql-restore --all-backup-files
--from-cloud | -C - Use cloud disk
Display a list of backup files from cloud disk.
php artisan backup:mysql-restore --from-cloud
--restore-latest-backup | -L - Restore latest backup file
Use latest backup file to restore database.
php artisan backup:mysql-restore --restore-latest-backup
--yes | -y - Confirms restoration action
Confirms database restoration without asking.
php artisan backup:mysql-restore --yes
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
:
Contribute and share ;-)
If you like this little piece of code share it with you friends and feel free to contribute with any improvements.
All versions of backup_by_table with dependencies
illuminate/console Version 5.*
illuminate/support Version 5.*
league/flysystem-aws-s3-v3 Version ~1.0