The use of PHP code to implement database backup can make the site management becomes very convenient, we can directly into the background operation can complete the database backup.
Key technologies:
1. First you have to get the tables in the database, the function mysql_list_tables (), and then you can save all the table names you get to an array.
2. Show create table name can get table structure.
3. Select * FROM table name to remove all records, use the loop to insert into ... Statement.
Implementation code:
Copy Code code as follows:
<?php
Header ("Content-type:text/html;charset=utf-8");
Configuration information
$cfg _dbhost = ' localhost ';
$cfg _dbname = ' FTDM ';
$cfg _dbuser = ' root ';
$cfg _dbpwd = ' root ';
$cfg _db_language = ' UTF8 ';
$to _file_name = "Ftdm.sql";
End configuration
Link Database
$link = mysql_connect ($cfg _dbhost, $cfg _dbuser, $cfg _dbpwd);
mysql_select_db ($cfg _dbname);
Select encoding
mysql_query ("Set names". $cfg _db_language);
What tables are in the database
$tables = Mysql_list_tables ($cfg _dbname);
Log these tables to an array
$tabList = Array ();
while ($row = Mysql_fetch_row ($tables)) {
$tabList [] = $row [0];
}
echo "In operation, please wait patiently ...<br/>";
$info = "------------------------------\ r \ n";
$info. = "-Date:". Date ("Y-m-d h:i:s", Time ()). " \ r \ n ";
$info. = "--for testing and learning only, this program is not suitable for handling large amounts of data \ r \ n";
$info. = "------------------------------\r\n\r\n";
File_put_contents ($to _file_name, $info, file_append);
Export the table structure of each table to a file
foreach ($tabList as $val) {
$sql = "Show create TABLE". $val;
$res = mysql_query ($sql, $link);
$row = Mysql_fetch_array ($res);
$info = "------------------------------\ r \ n";
$info. = "--Table structure for '". $val. " ' \ r \ n ';
$info. = "------------------------------\ r \ n";
$info. = "DROP TABLE IF EXISTS '". $val. " '; \ r \ n ';
$SQLSTR = $info. $row [1]. "; \ R\n\r\n ";
Append to File
File_put_contents ($to _file_name, $SQLSTR, file_append);
Releasing resources
Mysql_free_result ($res);
}
Export data from each table to a file
foreach ($tabList as $val) {
$sql = "SELECT * from". $val;
$res = mysql_query ($sql, $link);
If there is no data in the table, continue to the next table
if (mysql_num_rows ($res) <1) continue;
//
$info = "------------------------------\ r \ n";
$info. = "--Records for '". $val. " ' \ r \ n ';
$info. = "------------------------------\ r \ n";
File_put_contents ($to _file_name, $info, file_append);
Reading data
while ($row = Mysql_fetch_row ($res)) {
$SQLSTR = INSERT into '. $val. " ' VALUES (";
foreach ($row as $zd) {
$sqlStr. = "'" $zd. "',";
}
Remove the last comma and space
$SQLSTR = substr ($sqlStr, 0,strlen ($SQLSTR)-2);
$sqlStr. = "); \ r \ n";
File_put_contents ($to _file_name, $SQLSTR, file_append);
}
Releasing resources
Mysql_free_result ($res);
File_put_contents ($to _file_name, "\ r \ n", file_append);
}
echo "ok!";
?>