sql导出导入备份恢复

   public function db_download(){   $filename = I('sql');   //执行资源下载        // header("Content-Type:xls");// 接收类型        header("Content-Disposition:attachment;filename={$filename}");// 接收为 附件        // header("Content-Length:{$filesize}");// 接受大小        readfile("./Public/sql/{$filename}");// 输出文件   }

    public function localsql(){   if(!empty($_FILES['sqlpath']['tmp_name'])){   $config = array('savePath' => './Public/sql/','saveRule' => date ('Y-m-d.H-i-s.') .rand(100,999),);import('ORG.Net.UploadFile');$Upload = new UploadFile($config);$rst = $Upload -> uploadOne($_FILES['sqlpath']);if(!$rst){dump( $Upload -> getErrorMsg() );}else{$sqlname = $rst[0]['savename'];$path = './Public/sql/';   $cmd = 'mysql -h'.C('DB_HOST').' -u'.C('DB_USER').' -p'.C('DB_PWD').' '.C('DB_NAME').' < '.$path.$sqlname;      exec($cmd,$arr,$flag);   unlink($path.$sqlname);      if($flag == 0){   $this->redirect('Config/db_recover','',0.01,'<script>alert("导入成功");</script>');   }else{$this->redirect('Config/db_recover','',0.01,'<script>alert("导入失败");</script>');   }}   }    }

   // db恢复   public function db_recover(){   if(!empty($_POST)){   $path = './Public/sql/';   $Back = D('backup');   $id = I('post.id');   $data=$Back->select();   $sqlname = $Back -> where('id = ' . $id) -> getfield('sqlname');   $cmd = 'mysql -h'.C('DB_HOST').' -u'.C('DB_USER').' -p'.C('DB_PWD').' '.C('DB_NAME').' < '.$path.$sqlname;   exec($cmd,$arr,$flag);   if($flag == 0){   foreach($data as &$v){   $Back->save($v);   unset($v);   }   $this -> redirect('Config/db_recover' , '' , 0.01 , '<script>alert("导入成功");</script>');   }else{   $this -> redirect('Config/db_recover' , '' , 0.01 , '<script>alert("导入失败");</script>');   }   }else{   $this -> getdb(1);   $this -> getdb(2);   $this -> getdb(3);   $this -> getdb(4);   $this -> getdb(5);   $this -> getdb(6);   $this -> getdb(7);   $this->display();   }   }

// 数据库备份   public function db_backup(){   if(!empty($_POST)){   set_time_limit(0);   $path = APP_ROOT.'/Public/sql/';   // dump($path);   $Back = D('backup');   $_POST['sqlname'] = date('Y-m-d--H-i-s') . '.sql';$cmd = 'mysqldump -h '.C('DB_HOST').' -u'.C('DB_USER').' -p'.C('DB_PWD').' '.C('DB_NAME').' > '.$path.$_POST['sqlname'];   exec($cmd,$arr,$flag);   if($flag == 0){   $Back -> create();   if(  $Back->find( I('post.id') )  ){   $sqlname = $Back -> where('id = ' . I('post.id')) -> getfield('sqlname');   $back = $Back -> where('id = ' . I('post.id')) -> setfield('sqlname' , $_POST['sqlname']);   unlink($path.$sqlname);   }else{   $back = $Back -> add();   }   }      if( $back ){   $this -> redirect('Config/db_backup' , '' , 0.01 , '<script>alert("备份成功");</script>');   }else{   $this -> redirect('Config/db_backup' , '' , 0.01 , '<script>alert("备份失败");</script>');   }   }else{   $this -> getdb(1);   $this -> getdb(2);   $this -> getdb(3);   $this -> getdb(4);   $this -> getdb(5);   $this -> getdb(6);   $this -> getdb(7);   $this->display();   }   }

  // 获取当前备份   private function getdb($id){   $Back = D('backup');   $assign = 'db'.$id;   $sqlname = $Back -> where('id = ' . $id) -> getfield('sqlname');   $this->assign($assign , $sqlname);   }