yii2下console的使用之备份数据库

直接在console下面的controller下建一个controller，代码如下： <?php namespace console\controllers; use yii\console\Controller; use console\models\Mar; use console\models\DownloadRole; use console\models\Download; use yii; class BackupController extends Controller { public function actionIndex($uid, $file_path, $describe) { // $tables = Yii::$app->db->schema->getTableNames(); // var_dump($tables);die; // $uid = '22b11db4-e907-4f1f-8835-b9daab6e1f23'; $describe = date('Ymd',time()); $name = "/webser/www/backup/".$describe.".sql"; system("mysqldump -ulee -p111111 -h localhost download > ".$name, $i); $describe = date('Ymd',time()); $item = DownloadRole::find()->where(['uid' => $uid])->select('id')->asArray()->one(); $download = new Download(); $download->download_role_id = $item['id']; $download->file_path = $file_path; $download->describe = $describe; $result = $download->save(); return $result; } } 然后在你的项目根目录下运行：php yii backup/index uid file_path describe，这样子，就可以啦，记得把php加入path。

yii2下console的使用之备份数据库

微信号：腾讯云折扣返现

技术讨论QQ群： 863102326

作者: catherine

搜索

标签