Yii2.0 Console Backup RESTORE Database

Installing migration

Composer require e282486518/yii2-console-migration "@dev"
//or add "e282486518/" in Composer.json Yii2-console-migration ":" * " 
//and composer update

In the console\config\main.php.

' Controllermap ' = [
    ' migrate ' and ' = '
        class ' = ' E282486518\migration\consolecontroller ',
    ],
],

On the command line

PHP./yii migrate/backup all #备份全部表
php./yii migrate/backup table1,table2,table3 ... #备份多张表
php./yii migrate/ Backup table1 #备份一张表

php./yii migrate/up #恢复全部表

GitHub Address