TP 数据库还原

//数据库还原
    public function restore()
    {
        $session = $_SESSION['userName'];
         if(empty($session)) $this->ajaxReturn('','未登录!',-1);
        $filename = $this->_post('checked');
        $host=C('DB_HOST');
        $user=C('DB_USER');
        $password=C('DB_PWD');
        $dbname=C('DB_NAME');
        mysql_connect($host,$user,$password);
        mysql_select_db($dbname);
        $fname="./Down/Data/".$filename; //指定要恢复的MySQL备份文件路径,请自已修改此路径
        if(file_exists($fname)){
            $sql_value="";
            $cg=0;
            $sb=0;
            $sqls=file($fname);
            foreach($sqls as $sql){
                $sql_value.=$sql;
            }
            $a=explode(";\r\n", $sql_value);
            
            $total=count($a)-1;
            for($i=0;$i<$total;$i++){
               //执行命令
               if(mysql_query($a[$i])){
                   $cg+=1;
               }else{
                   $sb+=1;
                   $sb_command[$sb]=$a[$i];
               }
            }
            $arr['cg'] = $cg;
            $arr['total'] = $total;
            $arr['sb'] = $sb;
           // 显示错误信息
            if($sb>0){
                $this->ajaxReturn($arr,'',-1);
            }else{
                $this->ajaxReturn($arr,'',1);
            }            
        }else{
           $this->ajaxReturn('','MySQL备份文件不存在，请检查文件路径是否正确',-2);
        }
    }