MySQL data table is damaged PHP XML backup Mysql database

WBOY
Release: 2016-07-29 08:39:59
Original
735 people have browsed it

Implement XML backup of Mysql database collection using PHP
The following is the file code for backing up Mysql database through Apache+PHP under Linux:
File 1, Listtable.php (the file lists all tables in the database for selection and backup)
Please Select the tables to be backed up:

Copy the code The code is as follows:


$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

Copy code The code is as follows:



$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 Backup successful! ";?>


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 is not complicated. Through XML, we Various databases can be backed up. Of course, the backed up XML documents can also be restored to the database through related methods, which will not be described in detail here.

The above introduces the MySQL data table damage PHP XML backup Mysql database, including the content of MySQL data table damage. I hope it will be helpful to friends who are interested in PHP tutorials.

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!