PHPackages                             kingkoo1985/yii2-console-migration - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [CLI & Console](/categories/cli)
4. /
5. kingkoo1985/yii2-console-migration

ActiveYii2-extension[CLI & Console](/categories/cli)

kingkoo1985/yii2-console-migration
==================================

yii2命令行中使用migration备份和还原数据库

09PHP

Since Apr 26Pushed 8y ago1 watchersCompare

[ Source](https://github.com/kingkoo1985/yii2-console-migration)[ Packagist](https://packagist.org/packages/kingkoo1985/yii2-console-migration)[ RSS](/packages/kingkoo1985-yii2-console-migration/feed)WikiDiscussions master Synced today

READMEChangelogDependenciesVersions (1)Used By (0)

yii2使用migration备份和还原数据库
=======================

[](#yii2使用migration备份和还原数据库)

yii2使用migration备份和还原数据库，最初只想做一个在命令行中备份的功能，后来将类重组了，增加了其他扩展使用方法。

安装 Installation
---------------

[](#安装-installation)

安装此扩展的首选方式是通过 [composer](http://getcomposer.org/download/).

运行

```
composer require kingkoo1985/yii2-console-migration "@dev"

```

或者添加

```
"kingkoo1985/yii2-console-migration": "*"

```

到 `composer.json` 文件的对应地方.

命令行中备份数据表：
----------

[](#命令行中备份数据表)

在`console\config\main.php`中添加 :

```
'controllerMap' => [
    'migrate' => [
        'class' => 'kingkoo1985\migration\ConsoleController',
    ],
],
```

在命令行中使用方式：

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

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

```

在后台中备份数据表：
----------

[](#在后台中备份数据表)

在后台的控制器中，例如`PublicController`中加入下面的代码：

```
public function actions()
{
    return [
        'backup' => [
            'class' => 'kingkoo1985\migration\WebAction',
            'returnFormat' => 'json',
            'migrationPath' => '@console/migrations'
        ]
    ];
}
```

在后台中发送一个ajax请求到`/admin/public/backup?tables=yii2_ad,yii2_admin`即可。

其他使用方法：
-------

[](#其他使用方法)

对于想做更多扩展的朋友，可以直接继承`kingkoo1985\migration\components\MigrateCreate`

或者使用一下代码：

```
$migrate = Yii::createObject([
        'class' => 'kingkoo1985\migration\components\MigrateCreate',
        'migrationPath' => $this->migrationPath
]);
$migrate->create($table);
```

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity41

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/8fe0d2ebe4544037e9f0224d281a51460e8e59d7987e5119cf4ab1b91f6c7a92?d=identicon)[kingkoo1985](/maintainers/kingkoo1985)

---

Top Contributors

[![kingkoo1985](https://avatars.githubusercontent.com/u/8992116?v=4)](https://github.com/kingkoo1985 "kingkoo1985 (3 commits)")

### Embed Badge

![Health badge](/badges/kingkoo1985-yii2-console-migration/health.svg)

```
[![Health](https://phpackages.com/badges/kingkoo1985-yii2-console-migration/health.svg)](https://phpackages.com/packages/kingkoo1985-yii2-console-migration)
```

###  Alternatives

[wp-cli/wp-cli

WP-CLI framework

5.0k17.2M320](/packages/wp-cli-wp-cli)[consolidation/annotated-command

Initialize Symfony Console commands from annotated command class methods.

22569.8M19](/packages/consolidation-annotated-command)[chi-teck/drupal-code-generator

Drupal code generator

26947.8M5](/packages/chi-teck-drupal-code-generator)[seld/cli-prompt

Allows you to prompt for user input on the command line, and optionally hide the characters they type

24725.8M17](/packages/seld-cli-prompt)[illuminate/console

The Illuminate Console package.

12944.1M5.1k](/packages/illuminate-console)[php-tui/php-tui

Comprehensive TUI library heavily influenced by Ratatui

589747.0k6](/packages/php-tui-php-tui)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)