beaten-sect0r/yii2-db-manager

The db dump manager module for Yii2

Yii2 DB manager

Click on a :star:!, _(*1)

, _(*2)

MySQL/PostgreSQL Database Backup and Restore functionality, _(*3)

, _(*4)

Installation

The preferred way to install this extension is through composer., _(*5)

Either run, _(*6)

composer require --prefer-dist beaten-sect0r/yii2-db-manager "*"

or add, _(*7)

"beaten-sect0r/yii2-db-manager": "*"

to the require section of your composer.json file., _(*8)

Configuration

Once the extension is installed, simply add it in your config by:, _(*9)

Basic config/web.php, _(*10)

Advanced backend/config/main.php, _(*11)

Simple config

    'modules' => [
        'db-manager' => [
            'class' => 'bs\dbManager\Module',
            // path to directory for the dumps
            'path' => '@app/backups',
            // list of registerd db-components
            'dbList' => ['db'],
            // Flysystem adapter (optional) creocoder\flysystem\LocalFilesystem will be used as default. 
            'flySystemDriver' => 'creocoder\flysystem\LocalFilesystem',
            'as access' => [
                'class' => 'yii\filters\AccessControl',
                'rules' => [
                    [
                        'allow' => true,
                        'roles' => ['admin'],
                    ],
                ],
            ],
        ],
    ],

Advanced config

    'components' => [
        // https://github.com/creocoder/yii2-flysystem
        'backupStorage' => [
            'class' => 'creocoder\flysystem\FtpFilesystem',
            'host' => 'ftp.example.com',
            //'port' => 21,
            //'username' => 'your-username',
            //'password' => 'your-password',
            //'ssl' => true,
            //'timeout' => 60,
            //'root' => '/path/to/root',
            //'permPrivate' => 0700,
            //'permPublic' => 0744,
            //'passive' => false,
            //'transferMode' => FTP_TEXT,
        ],
    ],
    'modules' => [
        'db-manager' => [
            'class' => 'bs\dbManager\Module',
            // Flysystem adapter (optional) creocoder\flysystem\LocalFilesystem will be used as default. 
            'flySystemDriver' => 'creocoder\flysystem\LocalFilesystem',
            // path to directory for the dumps
            'path' => '@app/backups',
            // list of registerd db-components
            'dbList' => ['db', 'db1', 'db2'],
            // process timeout
            'timeout' => 3600,
            // additional mysqldump/pg_dump presets (available for choosing in dump and restore forms)
            'customDumpOptions' => [
                'mysqlForce' => '--force',
                'somepreset' => '--triggers --single-transaction',
                'pgCompress' => '-Z2 -Fc',
            ],
            'customRestoreOptions' => [
                'mysqlForce' => '--force',
                'pgForce' => '-f -d',
            ],
            // options for full customizing default command generation
            'mysqlManagerClass' => 'CustomClass',
            'postgresManagerClass' => 'CustomClass',
            // option for add additional DumpManagers
            'createManagerCallback' => function($dbInfo) {
                if ($dbInfo['dbName'] == 'exclusive') {
                    return new MyExclusiveManager;
                } else {
                    return false;
                }
            }
            'as access' => [
                'class' => 'yii\filters\AccessControl',
                'rules' => [
                    [
                        'allow' => true,
                        'roles' => ['admin'],
                    ],
                ],
            ],
        ],
    ],

Console config

    'modules' => [
        'db-manager' => [
            'class' => 'bs\dbManager\Module',
            // Flysystem adapter (optional) creocoder\flysystem\LocalFilesystem will be used as default. 
            'flySystemDriver' => 'creocoder\flysystem\LocalFilesystem',
            // path to directory for the dumps
            'path' => '@app/backups',
            // list of registerd db-components
            'dbList' => ['db'],
        ],
    ],

Make sure you create a writable directory named backup on app root directory., _(*12)

Usage

Pretty url's /db-manager, _(*13)

No pretty url's index.php?r=db-manager, _(*14)

Console usage

-db - db component, default value: db, _(*15)

-gz - gzip archive, _(*16)

-s - file storage, _(*17)

-f - file name, default last dump, _(*18)

Create dump, _(*19)

php yii dump/create -db=db -gz -s

Restore dump, _(*20)

php yii dump/restore -db=db -s -f=dump.sql

Deleting all dumps, _(*21)

php yii dump/delete-all

Test database connection, _(*22)

php yii dump/test-connection -db=db

Changelog

• Flysystem support
• Console support
• Multiple database management
• Ability for customize dump and restore options; dump and restore processors
• Ability for run operations asynchronously
• Ability for compressing dumps