PHP uses XML to back up MySQL database instance

Here is the file code for backing up the MySQL database via apache+php under Linux:
File one, listtable.php (file lists all tables in the database for backup selection)
Please select the table you want to back up:

The code is as follows	Copy Code
$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 the tables $i + +;} ?>

Document II, backup.php

The code is as follows

Copy Code

"") 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; //Below is the file action code $filename = $table. ". XML "; $fp =fopen ("$filename", "w"); Fwrite ($fp, $FILESTR); Fclose ($FP); Echo datasheet. $table. " Backup has been successful! ";? "

The

enables you to back up the selected tables in your database by using the above files.
The above mainly introduces the implementation of XML backup database through PHP operation method, in fact, is not complex, through XML, we can back up a variety of databases, of course, you can also use the relevant methods to restore the XML document back to the database