PHPackages                             jianyan74/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. [Database & ORM](/categories/database)
4. /
5. jianyan74/yii2-console-migration

ActiveYii2-extension[Database & ORM](/categories/database)

jianyan74/yii2-console-migration
================================

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

1.0.1(6y ago)616.6k↓16.7%2Apache-2.0PHP

Since Aug 6Pushed 6y ago2 watchersCompare

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

READMEChangelog (2)DependenciesVersions (3)Used By (0)

由于 [e282486518/yii2-console-migration](https://github.com/e282486518/yii2-console-migration) 不怎么维护 所以建立该项目

注意：如果你使用的是php7.2，那么yii必须使用v2.0.15.1以上，因为yii2核心类Object和php7.2的保留类Object冲突。

```
use yii\base\Object // PHP7.1以及之前版本
use yii\base\BaseObject // PHP7.2
```

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

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

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

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

[](#安装-installation)

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

运行

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

```

或者添加

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

```

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

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

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

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

```
'controllerMap' => [
    'migrate' => [
        'class' => 'jianyan\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' => 'jianyan\migration\WebAction',
            'returnFormat' => 'json',
            'migrationPath' => '@console/migrations'
        ]
    ];
}
```

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

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

[](#其他使用方法)

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

或者使用一下代码：

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

###  Health Score

33

—

LowBetter than 75% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity30

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity60

Established project with proven stability

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.

###  Release Activity

Cadence

Every ~0 days

Total

2

Last Release

2472d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/471d25dc73e2284afad914ef1fff768f91a03302c68c081ef0140e5785a54a10?d=identicon)[jianyan74](/maintainers/jianyan74)

---

Tags

consolemigrationyii2

### Embed Badge

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

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

###  Alternatives

[bizley/migration

Migration generator for Yii 2.

297374.3k11](/packages/bizley-migration)[dmstr/yii2-migrate-command

Console Migration Command with multiple paths/aliases support

31295.5k6](/packages/dmstr-yii2-migrate-command)[e282486518/yii2-console-migration

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

388.1k4](/packages/e282486518-yii2-console-migration)[c006/yii2-migration-utility

Automatically writes the create tables for migrations or create tables in general

63160.6k1](/packages/c006-yii2-migration-utility)[tmukherjee13/yii2-reverse-migration

Generate working migration classes from existing Database

2321.5k](/packages/tmukherjee13-yii2-reverse-migration)[hzhihua/yii2-dump

Generate the schema from an existing database

1828.5k1](/packages/hzhihua-yii2-dump)

PHPackages © 2026

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