2017 © Pedro Peláez
 

library dbmanager

A highly configurable database backup and restore solution for laravel projects

image

julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  • Sunday, February 28, 2016
  • by julianpitt
  • Repository
  • 1 Watchers
  • 0 Stars
  • 100 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 9 Versions
  • 1 % Grown

The README.md

Laravel Database Manager

A highly configurable database backup and restore solution for laravel 5 projects, (*1)

Install

Via Composer, (*2)

``` bash $ composer require julianpitt/dbmanager, (*3)


Add the service provider to your config/app.php file's provider array ``` php ... 'JulianPitt\DBManager\DBManagerServiceProvider', ...

Then publish the config after you update composer, (*4)

``` bash $ php artisan vendor:publish --provider="JulianPitt\DBManager\DBManagerServiceProvider" --tag="public", (*5)




## Usage ###Console For backups ``` bash php artisan dbman:backup

For restores ( currently in development ) ``` bash php artisan dbman:restore, (*6)



###File ``` php DBManager::hasPermission( {filesystem name} ); DBManager::backup(); DBManager::backup( {options array} );

Config

Backup

Defaults

prefix              => 'datetime'
suffix              => ''
filename            => '-db-manager'
compress            => true
keeplastonly        => false
filesystem          => "local"
location            => "/backups/"
useExtendedInsert   => true
timeoutInSeconds    => 60
tables              => ""
backupType          => "dataandstructure"
'individualFiles'   => env('DBMAN_OUTPUT_INDIVIDUAL', false),
'checkPermissions'  => env('DBMAN_CHECK_PERMISSIONS', true),
'failsafeEnabled'   =>  env('DBMAN_OUTPUT_FAILSAFE', true),
'failsafe'          => [
        'location'          => '/dbmanager/',
        'filesystem'        => 'local'
    ]

Options

``` bash -p --prefix=PREFIX The name of the file will get prefixed with this string. -s --suffix=SUFFIX The name of the file will get suffixed with this string. -f --filename=FILENAME The name of the file to output. -t --type=TYPE The type of dump to perform on the database ("datanadstructure/dataonly/structureonly) -k --keeplastonly=KEEPLASTONLY Keep the last backup or delete all previous backups (true/false) -c --compress=COMPRESS Compress the output file to .zip (true/false) -d --checkPermissions=CHECKPERMISSIONS Enable an initial check to see if the backup will run correctly [default: true] -b --failsafeEnabled=FAILSAFEENABLED Save a full backup in the failsafe location when performing a backup on some tables only [default: true] -i --individual=INDIVIDUAL Save each table to an individual file [default: false], (*7)



#### .env The following values can be changed inside your .env file ``` bash DBMAN_OUTPUT_COMPRESS - compress (boolean)[true|false] DBMAN_OUTPUT_KEEPLASTONLY - keeplastonly (boolean)[true|false] DBMAN_OUTPUT_FILESYSTEM - filesystem (string or array) e.g ['local','aws'] or 'local' DBMAN_OUTPUT_LOCATION - location (string) e.g '/backups/' DBMAN_OUTPUT_TABLES - tables (string) e.g 'laravel' or '' for the whole database DBMAN_OUTPUT_BACKUPTYPE - backupType (string) [dataonly|structureonly|dataandstructure] DBMAN_CHECK_PERMISSIONS - checkPermissions (boolean)[true|false] DBMAN_OUTPUT_FAILSAFE - failsafeEnabled (boolean)[true|false] DBMAN_OUTPUT_INDIVIDUAL - individualFiles (boolean)[true|false]

Change log

Please see CHANGELOG for more information what has changed recently., (*8)

Contributing

Please see CONTRIBUTING and CONDUCT for details., (*9)

Security

If you discover any security related issues, please email julian.pittas@gmail.com instead of using the issue tracker., (*10)

Credits

  • Julian Pittas

License

The MIT License (MIT). Please see License File for more information, (*11)

The Versions

28/02 2016

dev-master

9999999-dev https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt

28/02 2016

1.0.3.4

1.0.3.4 https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt

25/02 2016

1.0.3.3

1.0.3.3 https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt

25/02 2016

1.0.3.2

1.0.3.2 https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt

24/02 2016

1.0.3.1

1.0.3.1 https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt

23/02 2016

1.0.3

1.0.3.0 https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt

18/01 2016

1.0.2

1.0.2.0 https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt

18/01 2016

1.0.1

1.0.1.0 https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt

18/01 2016

1.0.0

1.0.0.0 https://github.com/julianpitt/dbmanager

A highly configurable database backup and restore solution for laravel projects

  Sources   Download

MIT

The Requires

 

The Development Requires

dbmanager laraveldatabasemanager julianpitt