yii 备份还原数据库

备份Model：

namespace backendmodels;

use Yii;
use yiidbActiveRecord;

class DbModel extends ActiveRecord{
	protected $dbdata_path = "dbdata";
	public function init(){
		header ( "Content-type: text/html;charset=utf-8" );  
	}

	/*
	*	获取所有数据表
	*/
	protected function getTables(){
        return Yii::$app->db->getSchema()->getTableNames();
	}

	/*
	* 备份地址
	*/
	protected function getBackUpPath(){
		$path = dirname(dirname(__FILE__)) . "/" . $this->dbdata_path;
		if(!file_exists($path)){
			@mkdir($path, 0777);
		}
		return $path;
	}

	/*
	*	文件名称
	*/
	protected function makeFileName(){
		$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
		$name = "";
		for($i = 0; $i<5; $i++){
			$name .= $chars[mt_rand(0, strlen($chars)-1)];
		}
		return date("Ymd")."_".$name.".sql";
	}

	/*
	* 给字段、表名 加上`
	*/
	protected function addStyle($str){
		 return "`{$str}`";  
	}

	/*
	*	获取表结构
	*/
	protected function getTableStructure($table){
		$data = Yii::$app->db->createCommand("SHOW CREATE TABLE " . $table)->queryAll();
		return $data[0]["Create Table"];
	}

	/*
	*	获取表数据
	*/
	protected function getTableDatas($table){
		$data = Yii::$app->db->createCommand("SELECT * FROM " . $table)->queryAll();
		$fields = "";
		$values = "";
		$content = "";
		foreach ($data as $key => $val) {
			$fields = array_keys($val);
			$values = array_values($val);
			$sql = "INSERT INTO " . $this->addStyle($table) ." (";
			$sql .= "`" . implode("`, `", $fields) . "`) VALUES (";
			$sql .= """ . implode("", "", $values) . ""); 
";
			$content .= $sql;
		}
		
		return $content;
	}

	/**
	* 备份数据库
	*/
	public function backUp(){
		$tables = $this->getTables();
		$path = $this->getBackUpPath();
		$fileName = $this->makeFileName();
		$content = "SET FOREIGN_KEY_CHECKS=0; 
";  
		foreach ($tables as $key => $val) {
			$content .= "DROP TABLE IF EXISTS ". $this->addStyle($val) .";
";
			$content .= $this->getTableStructure($val);
			$content .= ";
";
			$content .= $this->getTableDatas($val);
			$content .= "
";
		}

		$back_path = $this->getBackUpPath();
		$file_name = $this->makeFileName();
		$file = $back_path . "/" . $file_name;
		$fp = fopen($file, "w");
		@fwrite($fp, $content);
		fclose($fp);
	}

	/*
	* 获取所有的sql文件
	*/
	public function getSqlFiles(){
		$path = dirname(dirname(__FILE__)) . "/" . $this->dbdata_path;
		$sqls = [];
		if(file_exists($path)){
			$dir_handle = @opendir($path);
			while($file = @readdir($dir_handle)){
				$file_info = pathinfo($file);
				if($file_info["extension"] == "sql"){
					$sql["name"] = $file;
					$sql["create_time"] = date("Y-m-d", filectime($path . "/" . $file));
					$sqls[] = $sql;
				}
			}
		}
		return $sqls;
	}

	/**
	*	还原数据库
	*/
	public function recoverSqlFile($sqlFileName){
		$path = dirname(dirname(__FILE__)) . "/" . $this->dbdata_path;
		$sqlFile = $path . "/" . $sqlFileName;
		if(file_exists($sqlFile)){
			$sqls = file_get_contents($sqlFile);
			Yii::$app->db->createCommand($sqls)->execute();
		}
		

	}

	/*
	* 删除数据备份
	*/
	public function deleteSqlFile($sqlFileName){
		$path = dirname(dirname(__FILE__)) . "/" . $this->dbdata_path;
		$sqlFile = $path . "/" . $sqlFileName;
		if(file_exists($sqlFile)){
			@unlink($sqlFile);
		}
	}
}

控制器：

public function actionIndex(){
		$dbModel = new DbModel();
		$dataProvider =$dbModel->getSqlFiles();
		return $this->render("index", [
            "dataProvider" => $dataProvider,
        ]);
	}

	public function actionCreate(){
		$dbModel = new DbModel();
		$dbModel->backUp();
		return $this->redirect(["index"]);
	}

	public function actionUpdate($file){
		$dbModel = new DbModel();
		$dbModel->recoverSqlFile($file);
		return $this->redirect(["index"]);
	}

	public function actionDelete($file){
		$dbModel = new DbModel();
		$dbModel->deleteSqlFile($file);
		return $this->redirect(["index"]);
	}