Back up MySQL database with PHP and XML_PHP Tutorial

The following is the file code for backing up the Mysql database through Apache+PHP under Linux:
File 1, Listtable.php (the file lists all tables in the database for backup)
Please select what you want Backup table:
 
$con=mysql_connect('localhost','root','xswlily');
$lists=mysql_list_tables("embed",$con);
//Database Connection code
$i=0;
while($i$tb_name=mysql_tablename($lists,$i);
echo "".$tb_name ."
";
//List all tables
$i++;}
?>
File 2, Backup.php
"") header("Location:listtable.php");? >
 
$con=mysql_connect('localhost','root',' xswlily');
$query="select * from $table ";
//Database query
$ result=mysql_db_query("embed",$query,$con);
$filestr=""."?xml version="1.0" encoding="GB2312"?". ">";
$filestr.="".$table."s >";
while ($row=mysql_fetch_array($result))
//List all records
{$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;
//The following is the file operation code
$filename=$table.".xml";
$fp=fopen("$filename","w");
fwrite($fp,$filestr);
fclose($fp);
Echo "Data table ".$table." has been backed up successfully! ";?>
By operating the above files, you can back up the selected tables in the database.
The above mainly introduces the operation method of XML backup database through PHP. In fact, it does not It’s not complicated. Through XML, we can back up various databases. Of course, we can also restore the backed-up XML documents to the database through related methods.

http://www.bkjia.com/PHPjc/446876.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/446876.htmlTechArticleThe following is the file code for backing up the Mysql database through Apache+PHP under Linux: File 1. Listtable.php (The file lists all tables in the database for backup) Please select...