PHP code example of larikmc / yii2-db-backup

1. Go to this page and download the library: Download larikmc/yii2-db-backup library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

larikmc / yii2-db-backup example snippets




$params = array_merge(
    mon/config/params-local.php',
    DIRECTORY_SEPARATOR === '\\'
    ? 'D:\\OpenServer646\\modules\\MariaDB-11.8\\bin\\mysqldump.exe'
    : '';
$dumpBinary = getenv('DBBACKUP_DUMP_BINARY') ?: $defaultDumpBinary;

$config = [
    // ...
    'modules' => [
        // ...
        'dbbackup' => [
            'class' => larikmc\yii2dbbackup\Module::class,
            'controllerNamespace' => 'larikmc\\yii2dbbackup\\web\\controllers',
            'backupDir' => '@runtime/backups/db',
            'dumpBinary' => $dumpBinary,
            'retentionDays' => 14,
            'minFreeSpaceGb' => 2,
            'maxConcurrent' => 1,
            'accessRole' => '@',
            'consoleRoute' => 'dbbackup/backup/run',
            'autoCreateTable' => true,
        ],
    ],
    'components' => [
        // ...
        'urlManager' => [
            'enablePrettyUrl' => true,
            'showScriptName' => false,
            'rules' => [
                'db-backup/<action:\w+>' => 'dbbackup/backup/<action>',
            ],
        ],
    ],
];

return $config;




$params = array_merge(
    mon/config/params-local.php',
    DIRECTORY_SEPARATOR === '\\'
    ? 'D:\\OpenServer646\\modules\\MariaDB-11.8\\bin\\mysqldump.exe'
    : '';
$dumpBinary = getenv('DBBACKUP_DUMP_BINARY') ?: $defaultDumpBinary;

return [
    'id' => 'app-console',
    'basePath' => dirname(__DIR__),
    'bootstrap' => ['log'],
    'controllerNamespace' => 'console\\controllers',
    'modules' => [
        'dbbackup' => [
            'class' => larikmc\yii2dbbackup\Module::class,
            'controllerNamespace' => 'larikmc\\yii2dbbackup\\console\\controllers',
            'backupDir' => '@runtime/backups/db',
            'dumpBinary' => $dumpBinary,
            'retentionDays' => 14,
            'minFreeSpaceGb' => 2,
            'maxConcurrent' => 1,
            'consoleRoute' => 'dbbackup/backup/run',
            'autoCreateTable' => true,
        ],
    ],
    'params' => $params,
];


'modules' => [
    'dbbackup' => [
        'class' => larikmc\yii2dbbackup\Module::class,
        'controllerNamespace' => 'larikmc\\yii2dbbackup\\web\\controllers',
        'backupDir' => '@runtime/backups/db',
        'dumpBinary' => '', // путь к mariadb-dump/mysqldump, если нужен явный
        'retentionDays' => 14,
        'minFreeSpaceGb' => 2,
        'maxConcurrent' => 1,
        'accessRole' => '@',
        'consoleRoute' => 'dbbackup/backup/run',
        'autoCreateTable' => true,
    ],
],


'modules' => [
    'dbbackup' => [
        'class' => larikmc\yii2dbbackup\Module::class,
        'controllerNamespace' => 'larikmc\\yii2dbbackup\\console\\controllers',
        'backupDir' => '@runtime/backups/db',
        'dumpBinary' => '',
        'retentionDays' => 14,
        'minFreeSpaceGb' => 2,
        'maxConcurrent' => 1,
        'consoleRoute' => 'dbbackup/backup/run',
        'autoCreateTable' => true,
    ],
],


$defaultDumpBinary = DIRECTORY_SEPARATOR === '\\'
    ? 'D:\\OpenServer646\\modules\\MariaDB-11.8\\bin\\mysqldump.exe'
    : '';
$dumpBinary = getenv('DBBACKUP_DUMP_BINARY') ?: $defaultDumpBinary;


'dumpBinary' => $dumpBinary,


<a href="<?= \yii\helpers\Url::to(['/dbbackup/backup/index']) 

<li class="sz-nav__item">
    <a href="<?= \yii\helpers\Url::to(['/dbbackup/backup/index']) 

'rules' => [
    'db-backup/<action:\w+>' => 'dbbackup/backup/<action>',
]


<a href="<?= \yii\helpers\Url::to(['/db-backup/index'])