PHPackages                             yii-diandi/yii2-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. yii-diandi/yii2-migration

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

yii-diandi/yii2-migration
=========================

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

2.0.7(4y ago)0492↓100%4Apache-2.0PHP

Since Jul 8Pushed 4y ago1 watchersCompare

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

READMEChangelogDependenciesVersions (8)Used By (4)

注意：如果你使用的是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 yii-diandi/yii2-migration "@dev"

```

或者添加

```
"yii-diandi/yii2-migration": "*"

```

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

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

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

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

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

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

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

[](#其他使用方法)

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

或者使用一下代码：

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

###  Health Score

29

—

LowBetter than 60% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community13

Small or concentrated contributor base

Maturity60

Established project with proven stability

 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.

###  Release Activity

Cadence

Every ~105 days

Recently: every ~158 days

Total

7

Last Release

1503d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/46cef84bc40d75ea2a86c1746f139764841f3d133d34d951bf78ea39faffaa20?d=identicon)[wangchunsheng](/maintainers/wangchunsheng)

---

Top Contributors

[![yii-diandi](https://avatars.githubusercontent.com/u/34767187?v=4)](https://github.com/yii-diandi "yii-diandi (3 commits)")

---

Tags

consolemigrationyii2

### Embed Badge

![Health badge](/badges/yii-diandi-yii2-migration/health.svg)

```
[![Health](https://phpackages.com/badges/yii-diandi-yii2-migration/health.svg)](https://phpackages.com/packages/yii-diandi-yii2-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)