//数据库还原
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);
}
}
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);
}
}