用PHP实现XML备份Mysql数据库

以下是在Linux下通过Apache+PHP对Mysql数据库的备份的文件代码：

文件一、Listtable.php （文件列出数据库中的所有表格，供选择备份）

请选择要备份的表格:
<?
$con=mysql_connect('localhost','root','xswlily');
$lists=mysql_list_tables("embed",$con);
//数据库连接代码
$i=0;
while($i$tb_name=mysql_tablename($lists,$i);
echo "".$tb_name."
";
//列出所有的表格
$i++;}

?>

文件二、Backup.php
<?if ($table=="") header("Location:listtable.php");?>

<?
$con=mysql_connect('localhost','root','xswlily');
$query="select * from $table ";
//数据库查询
$result=mysql_db_query("embed",$query,$con);
$filestr="<"."?xml version="1.0" encoding="GB2312"?".">";
$filestr.="<".$table."s>";
while ($row=mysql_fetch_array($result))
//列出所有的记录
{$filestr.="<".$table.">";
$fields=mysql_list_fields("embed",$table,$con);
$j=0;
//$num_fields=mysql_field_name($fields,$j);
//echo $num_fields;
while ($j$num_fields=mysql_field_name($fields,$j);
$filestr.="<".$num_fields.">";
$filestr.=$row[$j];
$filestr.="";
$j++;}
$filestr.="";
}
$filestr.="";
echo $filestr;
//以下是文件操作代码
$filename=$table.".xml";
$fp=fopen("$filename","w");
fwrite($fp,$filestr);
fclose($fp);
Echo "数据表".$table."已经备份成功！";?>

通过以上文件的操作就可以实现对数据库中选定的表格进行备份.

以上主要介绍了通过PHP实现XML备份数据库的操作方法，其实并不复杂，通过XML，我们可以备份各种各样的数据库，当然也可以通过相关的方法将备份的XML文档恢复到数据库中，这里就不详细描述了。
来源:www.ProgramFan.Com

发表评论

网友评论

Replica Watches Jewelry Replica HandBags
作者访客于 2008-11-25 21:39:09

Replica Watches,Fake Watches,Replica Watch,Fake Watch,Wholesale Watches,Wholesale Replica Watches,Jewelry Watches,Replica Jewelry Watches.

Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Handbag, Replica Handbag, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Handbags, Replica Handbags, Wholesale Replica Watches, Wholesale Replica Watches, Replica Watches, Replica Watches, Fake Raymond Weil, Fake Raymond Weil, Replica Audemars Piguet Watch, Replica Audemars Piguet Watch, Zenith Watch Replica, Zenith Watch Replica, Audemars Piguet Watches, Audemars Piguet Watches, Replica Corum Watch, Replica Corum Watch, Replica Rolex Watches, Replica Rolex Watches, Longines Watches, Longines Watches, Replica Bvlgari Watches, Replica Bvlgari Watches, Rado Watches Replica, Rado Watches Replica, Fake Emporio Armani Watches, Fake Emporio Armani Watches, Patek Philippe Replica Watch, Patek Philippe Replica Watch, Ebel Replica Watches, Ebel Replica Watches, Piaget Replica Watch, Piaget Replica Watch, Breitling Watch, Breitling Watch, Fake Citizen Watches, Fake Citizen Watches, Jaeger LeCoultre Watch, Jaeger LeCoultre Watch, Patek Philippe Replica, Patek Philippe Replica, Vacheron Constantin Watch, Vacheron Constantin Watch, Rolex Replica, Rolex Replica, Replica TAG Heuer Watch, Replica TAG Heuer Watch,

Replica Watches Jewelry Replica HandBags
作者访客于 2008-11-26 01:12:39

Replica Watches,Fake Watches,Replica Watch,Fake Watch,Wholesale Watches,Wholesale Replica Watches,Jewelry Watches,Replica Jewelry Watches.

Replica Watch, Replica Watch, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Corum Replica Watch, Corum Replica Watch, Fake Emporio Armani, Fake Emporio Armani, Oris Watches Replica, Oris Watches Replica, Fake Piaget Watches, Fake Piaget Watches, Replica Cartier, Replica Cartier, Tudor Watches, Tudor Watches, IWC Watches, IWC Watches, Bvlgari Watch Replica, Bvlgari Watch Replica, Omega Watch Replica, Omega Watch Replica, Piaget Replica Watches, Piaget Replica Watches, Christian Dior Replica Watch, Christian Dior Replica Watch, Raymond Watches Replica, Raymond Watches Replica, Replica Raymond Weil Watch, Replica Raymond Weil Watch, Replica Rolex, Replica Rolex, Fake Chanel Watches, Fake Chanel Watches, Ebel Watches, Ebel Watches, Replica Chanel Watches, Replica Chanel Watches, Fake TAG Heuer, Fake TAG Heuer, Swatch Watches Replica, Swatch Watches Replica, Fake Audemars Piguet Watches, Fake Audemars Piguet Watches,

fghdfgj
作者访客于 2008-12-07 15:07:26