phpmysql数据库备份程序

 
	 
	 
	 
	 
	 
	 
	 
	 
	 
	 
	
 
	esweb系统数据管理 
	
 
	 
数据备份
 
	    
数据还原
 
	 
数据优化 
	
 
	
 
	 如果需要备份、还原或者优化 大量的数据 , 推荐使用"帝国备份王2010" 
 
	 
	
 
	
 
	 
esweb系统数据备份
 
	
 
	
 
	 
选择备份方式
 
	    
备份全部数据  
	    备份单张表数据   
	    请选择 
	    query("show table status from $mysqldb"); 
	    while($d->nextrecord()){ 
	    echo "f(&＃39;name&＃39;)."&＃39;>".$d->f(&＃39;name&＃39;)."";} 
	     
	    
 
	
 
	
 
	 
选择目标位置
 
	    
备份到服务器  
	    备份到本地
 
	
 
	
 
	 
使用分卷备份
 
	    
 
	    分卷备份  k (只有选择备份到服务器,才能使用分卷备份功能)
 
	
 
	
 
	 
程序说明
 
	    
1.对于较大的数据表,强烈建议使用分卷备份. 
	    
2.只有选择备份到服务器,才能使用分卷备份功能. 
	    
 
	
 
	
 
	 
 
 
	
 
	
 
	 
	query("show table status from $mysqldb")) 
	{$msgs[]="读数据库结构错误"; show_msg($msgs); pageend();} 
	$sql=""; 
	while($d->nextrecord($tables)) 
	{ 
	$table=$d->f("name"); 
	$sql.=make_header($table); 
	$d->query("select * from $table"); 
	$num_fields=$d->nf(); 
	while($d->nextrecord()) 
	{$sql.=make_record($table,$num_fields);} 
	} 
	$filename=date("ymd",time())."_all.sql"; 
	if($_post[&＃39;weizhi&＃39;]=="localpc") down_file($sql,$filename); 
	elseif($_post[&＃39;weizhi&＃39;]=="server") 
	{if(write_file($sql,$filename)) 
	$msgs[]="全部数据表数据备份完成,生成备份文件&＃39;$backup/$filename&＃39;"; 
	else $msgs[]="备份全部数据表失败"; 
	show_msg($msgs); 
	pageend(); 
	} 
	/*-----------------不要卷结束*/}/*-----------------------*/ 
	/*-----------------分卷*/else{/*-------------------------*/ 
	if(!$_post[&＃39;filesize&＃39;]) 
	{$msgs[]="请填写备份文件分卷大小"; show_msg($msgs);pageend();} 
	if(!$tables=$d->query("show table status from $mysqldb")) 
	{$msgs[]="读数据库结构错误"; show_msg($msgs); pageend();} 
	$sql=""; $p=1; 
	$filename=date("ymd",time())."_all"; 
	while($d->nextrecord($tables)) 
	{ 
	$table=$d->f("name"); 
	$sql.=make_header($table); 
	$d->query("select * from $table"); 
	$num_fields=$d->nf(); 
	while($d->nextrecord()) 
	{$sql.=make_record($table,$num_fields); 
	if(strlen($sql)>=$_post[&＃39;filesize&＃39;]*1000){ 
	     $filename.=("_v".$p.".sql"); 
	     if(write_file($sql,$filename)) 
	     $msgs[]="全部数据表-卷-".$p."-数据备份完成,生成备份文件&＃39;$backup/$filename&＃39;"; 
	     else $msgs[]="备份表-".$_post[&＃39;tablename&＃39;]."-失败"; 
	     $p++; 
	     $filename=date("ymd",time())."_all"; 
	     $sql="";} 
	} 
	} 
	if($sql!=""){$filename.=("_v".$p.".sql");   
	if(write_file($sql,$filename)) 
	$msgs[]="全部数据表-卷-".$p."-数据备份完成,生成备份文件&＃39;$backup/$filename&＃39;";} 
	show_msg($msgs); 
	/*---------------------分卷结束*/}/*--------------------------------------*/ 
	/*--------备份全部表结束*/}/*---------------------------------------------*/ 
	/*--------备份单表------*/elseif($_post[&＃39;bfzl&＃39;]=="danbiao"){/*------------*/ 
	if(!$_post[&＃39;tablename&＃39;]) 
	{$msgs[]="请选择要备份的数据表"; show_msg($msgs); pageend();} 
	/*--------不分卷*/if(!$_post[&＃39;fenjuan&＃39;]){/*-------------------------------*/ 
	$sql=make_header($_post[&＃39;tablename&＃39;]); 
	$d->query("select * from ".$_post[&＃39;tablename&＃39;]); 
	$num_fields=$d->nf(); 
	while($d->nextrecord()) 
	{$sql.=make_record($_post[&＃39;tablename&＃39;],$num_fields);} 
	$filename=date("ymd",time())."_".$_post[&＃39;tablename&＃39;].".sql"; 
	if($_post[&＃39;weizhi&＃39;]=="localpc") down_file($sql,$filename); 
	elseif($_post[&＃39;weizhi&＃39;]=="server") 
	{if(write_file($sql,$filename)) 
	$msgs[]="表-".$_post[&＃39;tablename&＃39;]."-数据备份完成,生成备份文件&＃39;$backup/$filename&＃39;"; 
	else $msgs[]="备份表-".$_post[&＃39;tablename&＃39;]."-失败"; 
	show_msg($msgs); 
	pageend(); 
	} 
	/*----------------不要卷结束*/}/*------------------------------------*/ 
	/*----------------分卷*/else{/*--------------------------------------*/ 
	if(!$_post[&＃39;filesize&＃39;]) 
	{$msgs[]="请填写备份文件分卷大小"; show_msg($msgs);pageend();} 
	$sql=make_header($_post[&＃39;tablename&＃39;]); $p=1;  
	$filename=date("ymd",time())."_".$_post[&＃39;tablename&＃39;]; 
	$d->query("select * from ".$_post[&＃39;tablename&＃39;]); 
	$num_fields=$d->nf(); 
	while ($d->nextrecord())  
	{  
	    $sql.=make_record($_post[&＃39;tablename&＃39;],$num_fields); 
	      if(strlen($sql)>=$_post[&＃39;filesize&＃39;]*1000){ 
	     $filename.=("_v".$p.".sql"); 
	     if(write_file($sql,$filename)) 
	     $msgs[]="表-".$_post[&＃39;tablename&＃39;]."-卷-".$p."-数据备份完成,生成备份文件&＃39;$backup/$filename&＃39;"; 
	     else $msgs[]="备份表-".$_post[&＃39;tablename&＃39;]."-失败"; 
	     $p++; 
	     $filename=date("ymd",time())."_".$_post[&＃39;tablename&＃39;]; 
	     $sql="";} 
	} 
	if($sql!=""){$filename.=("_v".$p.".sql");   
	if(write_file($sql,$filename)) 
	$msgs[]="表-".$_post[&＃39;tablename&＃39;]."-卷-".$p."-数据备份完成,生成备份文件&＃39;$backup/$filename&＃39;";} 
	show_msg($msgs); 
	/*----------分卷结束*/}/*--------------------------------------------------*/ 
	/*----------备份单表结束*/}/*----------------------------------------------*/ 
	/*---*/}/*-------------主程序结束------------------------------------------*/ 
	function write_file($sql,$filename) 
	{ 
	$re=true; 
	global $backup; 
	if(!@$fp=fopen($backup."/".$filename,"w+")) {$re=false; echo "failed to open target file";} 
	if(!@fwrite($fp,$sql)) {$re=false; echo "failed to write file";} 
	if(!@fclose($fp)) {$re=false; echo "failed to close target file";} 
	return $re; 
	} 
	function down_file($sql,$filename) 
	{ 
	ob_end_clean(); 
	header("content-encoding: none"); 
	header("content-type: ".(strpos($_server[&＃39;http_user_agent&＃39;], &＃39;msie&＃39;) ? &＃39;application/octetstream&＃39; : &＃39;application/octet-stream&＃39;)); 
	    
	header("content-disposition: ".(strpos($_server[&＃39;http_user_agent&＃39;], &＃39;msie&＃39;) ? &＃39;inline; &＃39; : &＃39;attachment; &＃39;)."filename=".$filename); 
	    
	header("content-length: ".strlen($sql)); 
	header("pragma: no-cache"); 
	    
	header("expires: 0"); 
	echo $sql; 
	$e=ob_get_contents(); 
	ob_end_clean(); 
	} 
	function writeable($dir) 
	{ 
	if(!is_dir($dir)) { 
	@mkdir($dir, 0777); 
	} 
	if(is_dir($dir))  
	{ 
	if($fp = @fopen("$dir/test.test", &＃39;w&＃39;)) 
	    { 
	@fclose($fp); 
	@unlink("$dir/test.test"); 
	$writeable = 1; 
	}  
	else { 
	$writeable = 0; 
	} 
	} 
	return $writeable; 
	} 
	function make_header($table) 
	{global $d; 
	$sql="drop table if exists ".$table." "; 
	$d->query("show create table ".$table); 
	$d->nextrecord(); 
	$tmp=preg_replace("/ /","",$d->f("create table")); 
	$sql.=$tmp." "; 
	return $sql; 
	} 
	function make_record($table,$num_fields) 
	{global $d; 
	$comma=""; 
	$sql .= "insert into ".$table." values("; 
	for($i = 0; $i <$num_fields; $i++)  
	{$sql .= ($comma."&＃39;".mysql_escape_string($d->record[$i])."&＃39;"); $comma = ",";} 
	$sql .= ") "; 
	return $sql; 
	} 
	function show_msg($msgs) 
	{ 
	$title="提示："; 
	echo ""; 
	echo ""; 
	echo "
".$title."

"; 
	while (list($k,$v)=each($msgs)) 
	{ 
	echo "
".$v."
"; 
	} 
	echo "
"; 
	} 
	function pageend() 
	{ 
	exit(); 
	} 
	 
	


 
	
 
	
 
	 
	 
	class db{ 
	var $linkid; 
	var $sqlid; 
	var $record; 
	function db($host="",$username="",$password="",$database="") 
	{ 
	if(!$this->linkid)    @$this->linkid = mysql_connect($host, $username, $password) or die("连接服务器失败."); 
	@mysql_select_db($database,$this->linkid) or die("无法打开数据库"); 
	return $this->linkid;} 
	function query($sql) 
	{if($this->sqlid=mysql_query($sql,$this->linkid)) return $this->sqlid; 
	else { 
	    $this->err_report($sql,mysql_error); 
	return false;} 
	} 
	function nr($sql_id="") 
	{if(!$sql_id) $sql_id=$this->sqlid; 
	return mysql_num_rows($sql_id);} 
	function nf($sql_id="") 
	{if(!$sql_id) $sql_id=$this->sqlid; 
	return mysql_num_fields($sql_id);} 
	function nextrecord($sql_id="") 
	{if(!$sql_id) $sql_id=$this->sqlid; 
	if($this->record=mysql_fetch_array($sql_id))    return $this->record; 
	else return false; 
	} 
	function f($name) 
	{ 
	if($this->record[$name]) return $this->record[$name]; 
	else return false; 
	} 
	function close() {mysql_close($this->linkid);} 
	function lock($tblname,$op="write") 
	{if(mysql_query("lock tables ".$tblname." ".$op)) return true; else return false;} 
	function unlock() 
	{if(mysql_query("unlock tables")) return true; else return false;} 
	function ar() { 
	      return @mysql_affected_rows($this->linkid); 
	    } 
	function i_id() { 
	    return mysql_insert_id(); 
	} 
	function err_report($sql,$err) 
	{ 
	echo "mysql查询错误
"; 
	echo "查询语句：".$sql."
"; 
	echo "错误信息：".$err; 
	}//开源代码phprm.com 
	/****************************************类结束***************************/ 
	 
	global $mysqlhost, $mysqluser, $mysqlpwd, $mysqldb, $backup; 
	$mysqlhost = $mydbhost;          //host name 
	$mysqluser = $mydbuser;          //login name 
	$mysqlpwd = $mydbpw;             //password 
	$mysqldb = $mydbname;            //name of database 
	$d=new db($mysqlhost,$mysqluser,$mysqlpwd,$mysqldb); 
	$d->query("set names &＃39;utf8&＃39;");

本文链接:

收藏随意^^请保留教程地址.