MySql备份还原系统_mysql还原资源-CSDN文库

共9个文件

php：7个

htm：1个

gif：1个

另类其它

4星 · 超过85%的资源需积分: 50 151 浏览量 2002-08-25 00:00:00 上传评论 1 收藏 6KB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

2002825144856.rar （9个子文件）

dbcopy.php 2KB

down.php 220B

main.php 2KB

dbback.php 4KB

index.php 396B

tablecopy.php 4KB

tableback.php 2KB

arrowhead.gif 75B

untitled.htm 177B

<title>MySQL数据库备份/还原</title> <body bgcolor="#CCCCCC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <? set_time_limit(900); if($action == "") { ?> <table width="100%" border="1" cellspacing="0" cellpadding="2" align="center"> <tr bgcolor="#666666"> <td colspan="2" height="24"> <div align="center"><font color="#FFFFFF" size="2">MYSQL数据库还原</font></div> </td> </tr> <form method=post> <tr> <td colspan="2"><font size="2">主机名 <input type="text" name="host" size="15" value="localhost"><input type=hidden name=action value=login> </font></td> </tr> <tr> <td colspan="2"><font size="2">用户名 <input type="text" name="user" size="15"> </font></td> </tr> <tr> <td colspan="2"><font size="2">密　码 <input type="password" name="pass" size="15"> </font></td> </tr> <tr> <td colspan="2"> <div align="center"> <input type="submit" name="Submit" value=" 登录 "> </div> </td> </tr> </form> </table> <? } elseif($action == "login") { mysql_connect($host,$user,$pass); ?> <table width="100%" border="1" cellspacing="0" cellpadding="2" align="center" bordercolorlight="#000000" bordercolordark="#FFFFFF" bordercolor="#000000"> <tr bgcolor="#666666"> <td colspan="2" height="24"> <div align="center"><font color="#FFFFFF" size="2">选择要还原的数据库</font></div> </td> </tr> </table> <? $dbresult = mysql_list_dbs(); for($i=0;$i<mysql_numrows($dbresult);$i++) { $db=mysql_dbname($dbresult,$i); ?> <table width="100%" border="1" cellspacing="0" cellpadding="2" align="center"> <tr> <form method=post> <td colspan="3"> <input type=hidden name=action value="do"> <input type=hidden name=host value="<?echo $host?>"> <input type=hidden name=user value="<?echo $user?>"> <input type=hidden name=pass value="<?echo $pass?>"> <input type=hidden name=db value="<?echo $db?>"> <?echo $db?> </td> <td width="30"> <div align="center"> <input type=submit name=submit value="还原"> </div> </td> </form> </tr> </table> <? } } elseif(($action == "do") && ($submit == "还原")) { mysql_connect($host,$user,$pass); $path=$db; if(!file_exists("$path/$db.db")) { echo "<br><br>数据库备份文件 $db.db 不存在！"; exit(); } //处理主数据库文件 $handle = fopen("$path/$db.db","r"); $message = file("$path/$db.db"); $pointer = 0; $tablenum = chop($message[$pointer++]); ?> <script> function changezt(){ parent.main.zt.zt.value=' ' } </script> <table width="100%" border="0" cellspacing="2" cellpadding="2"><tr bgcolor="#666666"> <td height="22"> <div align="center"><font color="#FFFFFF" size="2">选择需要还原的数据表</font></div> </td> </tr> <tr> <td> <table width="100%" border="1" cellspacing="0" cellpadding="2" bordercolorlight="#000000" bordercolordark="#FFFFFF" bordercolor="#000000"> <?php for($p=0;$p<$tablenum;$p++){ $tbname[$p]=chop($message[$pointer++]); $checktb="tb[".$p."]"; ?> <form method="get" name="stt" action="tableback.php" target="down" > <tr bgcolor="#FFFFFF"> <td width="30"> <div align="center"><img src="arrowhead.gif" width="11" height="11"> </div> </td> <td> <input type=hidden name=table value="<?php echo "$tbname[$p]"; ?>"> <input type=hidden name=db value="<?echo $db?>"> <input type=hidden name=pass value="<?echo $pass?>"> <input type=hidden name=user value="<?echo $user?>"> <input type=hidden name=host value="<?echo $host?>"> <?php echo "$tbname[$p]"; ?> </td> <td width="46"> <div align="center"> <input type=submit name=submit value="还原"> </div> </td> </tr></form> <?php } ?> </table> </td> </tr> <tr bgcolor="#666666"> <td> <div align="center"></div> </td> </tr> </table> <? } ?>

评论收藏

内容反馈