php教程 php手册 php mysql 数据库备份程序

php mysql 数据库备份程序

May 26, 2016 pm 03:22 PM
mysql php 데이터베이스 백업

提供一款实例的php mysql 数据库备份程序,很好方法的可以对你的数据库进行在线实时备份,这样可以保存数据库的安全,并且他是以.sql文件保存在bakdata目录还日期生成的数据库备份文件的,代码如下:

<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> 
	<html xmlns="http://www.w3.org/1999/xhtml"> 
	<head> 
	<meta http-equiv="content-type" content="text/html; charset=utf-8" /> 
	<link type="text/css" rel="stylesheet" href="common/control.css"> 
	<script type="text/javascript" language="javascript" src="common/admin.otable.js"></script> 
	<script type="text/javascript" language="javascript" src="common/include.func.js"></script> 
	<title>数据管理</title> 
	<style type="text/css"> 
	span {padding-left:8px;} 
	</style> 
	</head> 
	<body class="contentbody"> 
	<div class="maindiv"> 
	<span class="ctitle">esweb系统数据管理</span> 
	<ul class="cmenu"> 
	 <li><a href="sql_backup.php">数据备份</a></li> 
	    <li><a href="sql_restore.php">数据还原</a></li> 
	 <li><a href="sql_optimize.php">数据优化</a> 
	</ul> 
	<div class="concontent"> 
	<?php 
	/*--------------界面--------------*/if(!$_post[&#39;act&#39;]){/*----------------------*/ 
	$msgs[]="服务器备份目录为$backup"; 
	$msgs[]="对于较大的数据表,强烈建议使用分卷备份"; 
	$msgs[]="只有选择备份到服务器,才能使用分卷备份功能"; 
	//show_msg($msgs); 
	 
	<div class="thead"><span class="left"><img  src="/static/imghw/default1.png"  data-src="images/icon2/into.gif"  class="lazy"   align="absmiddle" / alt="php mysql 数据库备份程序 " > 如果需要备份、还原或者优化<font color="red"> 大量的数据 </font>, 推荐使用"<a href="http://www.phome.net/ebak2010/" target="_blank">帝国备份王2010</a>"</span> <span class="right"></span></div> 
	<form name="myform" method="post" action="sql_backup.php"> 
	<table cellpadding="" cellspacing="0" border="0" width="100%" class="ctable" id="otable" align="center"> 
	<tr> 
	 <th colspan="2">esweb系统数据备份</th> 
	</tr> 
	<tr> 
	 <td align="right" width="250">选择备份方式</td> 
	    <td><input type="radio" name="bfzl" value="quanbubiao" checked="checked" />备份全部数据  
	    <input type="radio" name="bfzl" value="danbiao" />备份单张表数据   
	    <select name="tablename"><option value="">请选择</option> 
	    <?php 
	    $d->query("show table status from $mysqldb"); 
	    while($d->nextrecord()){ 
	    echo "<option value=&#39;".$d->f(&#39;name&#39;)."&#39;>".$d->f(&#39;name&#39;)."</option>";} 
	     
	    </select></td> 
	</tr> 
	<tr> 
	 <td align="right">选择目标位置</td> 
	    <td><input type="radio" name="weizhi" value="server" checked="checked" />备份到服务器  
	    <input type="radio" name="weizhi" value="localpc" />备份到本地</td> 
	</tr> 
	<tr> 
	 <td align="right">使用分卷备份</td> 
	    <td><input type="checkbox" name="fenjuan" value="yes" checked="checked" /> 
	    分卷备份 <input name="filesize" type="text" value="1260" size="10" class="text2" /> k <span>(只有选择备份到服务器,才能使用分卷备份功能)</span></td> 
	</tr> 
	<tr> 
	 <td align="right">程序说明</td> 
	    <td>1.对于较大的数据表,强烈建议使用分卷备份. 
	    <br>2.只有选择备份到服务器,才能使用分卷备份功能. 
	    </td> 
	</tr> 
	<tr> 
	 <td align="center" colspan="2"><input type="submit" id="act" name="act" value="备 份" class="button" /> <input type="reset" value="重 置" class="button" /></td> 
	</tr> 
	</table> 
	</form> 
	<?php /*-------------界面结束-------------*/}/*---------------------------------*/ 
	/*----*/else{/*--------------主程序-----------------------------------------*/ 
	if($_post[&#39;weizhi&#39;]=="localpc"&&$_post[&#39;fenjuan&#39;]==&#39;yes&#39;) 
	{$msgs[]="只有选择备份到服务器,才能使用分卷备份功能"; 
	show_msg($msgs); pageend();} 
	if($_post[&#39;fenjuan&#39;]=="yes"&&!$_post[&#39;filesize&#39;]) 
	{$msgs[]="您选择了分卷备份功能,但未填写分卷文件大小"; 
	show_msg($msgs); pageend();} 
	if($_post[&#39;weizhi&#39;]=="server"&&!writeable($backup)) 
	{$msgs[]="备份文件存放目录&#39;$backup&#39;不可写,请修改目录属性"; 
	show_msg($msgs); pageend();} 
	/*----------备份全部表-------------*/if($_post[&#39;bfzl&#39;]=="quanbubiao"){/*----*/ 
	/*----不分卷*/if(!$_post[&#39;fenjuan&#39;]){/*--------------------------------*/ 
	if(!$tables=$d->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 "<table width=&#39;100%&#39; border=&#39;0&#39; cellpadding=&#39;0&#39; cellspacing=&#39;0&#39;>"; 
	echo "<tr><td>".$title."</td></tr>"; 
	echo "<tr><td><br><ul>"; 
	while (list($k,$v)=each($msgs)) 
	{ 
	echo "<li>".$v."</li>"; 
	} 
	echo "</ul></td></tr></table>"; 
	} 
	function pageend() 
	{ 
	exit(); 
	} 
	 
	</div><br /><br /> 
	</div> 
	</div> 
	</body> 
	</html> 
	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查询错误<br>"; 
	echo "查询语句:".$sql."<br>"; 
	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;");
로그인 후 복사

本文链接:

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

본 웹사이트의 성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.

뜨거운 기사 태그

메모장++7.3.1

메모장++7.3.1

사용하기 쉬운 무료 코드 편집기

SublimeText3 중국어 버전

SublimeText3 중국어 버전

중국어 버전, 사용하기 매우 쉽습니다.

스튜디오 13.0.1 보내기

스튜디오 13.0.1 보내기

강력한 PHP 통합 개발 환경

드림위버 CS6

드림위버 CS6

시각적 웹 개발 도구

SublimeText3 Mac 버전

SublimeText3 Mac 버전

신 수준의 코드 편집 소프트웨어(SublimeText3)

Ubuntu 및 Debian용 PHP 8.4 설치 및 업그레이드 가이드 Ubuntu 및 Debian용 PHP 8.4 설치 및 업그레이드 가이드 Dec 24, 2024 pm 04:42 PM

Ubuntu 및 Debian용 PHP 8.4 설치 및 업그레이드 가이드

CakePHP 날짜 및 시간 CakePHP 날짜 및 시간 Sep 10, 2024 pm 05:27 PM

CakePHP 날짜 및 시간

CakePHP 파일 업로드 CakePHP 파일 업로드 Sep 10, 2024 pm 05:27 PM

CakePHP 파일 업로드

CakePHP 라우팅 CakePHP 라우팅 Sep 10, 2024 pm 05:25 PM

CakePHP 라우팅

MySQL 8.4에서 mysql_native_password가 로드되지 않음 오류를 수정하는 방법 MySQL 8.4에서 mysql_native_password가 로드되지 않음 오류를 수정하는 방법 Dec 09, 2024 am 11:42 AM

MySQL 8.4에서 mysql_native_password가 로드되지 않음 오류를 수정하는 방법

CakePHP 토론 CakePHP 토론 Sep 10, 2024 pm 05:28 PM

CakePHP 토론

CakePHP 빠른 가이드 CakePHP 빠른 가이드 Sep 10, 2024 pm 05:27 PM

CakePHP 빠른 가이드

CakePHP 프로젝트 구성 CakePHP 프로젝트 구성 Sep 10, 2024 pm 05:25 PM

CakePHP 프로젝트 구성

See all articles