php - 我如何在 codeigniter 中运行 mysql 转储文件

Question

$folder=FCPATH."application\\models\\new.sql";
$filez=fopen($folder,'w');
$r2=str_replace("cms_project_db","new_cms",$filez);

$new=fwrite($filez,$r2);

$content=file_get_contents($new);
$arr=explode(";",$content);
foreach($arr as $value=>$val)
{
    $this->db->query($val);
}       

我想从 SQL 转储文件中获取所有内容并更改数据库名称，然后执行所有查询，但出现此错误:

A Database Error Occurred

Answer 1

您可以使用以下脚本，希望它能帮助您:

$this->load->dbutil();

        $prefs = array(     
                'format'      => 'zip',             
                'filename'    => 'my_backup.sql'
              );


        $backup =& $this->dbutil->backup($prefs); 

        $db_name = 'backup-'. date("Y-m-d-H-i-s") .'.zip';
        $save = 'path_to_file/'.$db_name;

        $this->load->helper('file');
        write_file($save, $backup); 


        $this->load->helper('download');
        force_download($db_name, $backup);