PHP implementation export MySQL database as. sql file instance (copy phpmyadmin export function) _php tutorial

Database backup with PHP code can make the management of the site very convenient, we can directly into the background operation to complete the database backup.

Key technologies:

1. First to get the tables in the database, the function mysql_list_tables (), and then you can save all the table names obtained to an array.
2. The Show create table table name can be used to get the tables structure.
3. Select * FROM table name to take out all records, with loop stitching into the insert into ... Statement.

Implementation code:
Copy the Code code as follows:

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 the encoding
mysql_query ("Set names". $cfg _db_language);
What tables 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 is running, please be patient ...
";
$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 processing super-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),
//Release 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);
}
Freeing resources
Mysql_free_result ($res);
File_put_contents ($to _file_name, "\ r \ n", file_append);
}

echo "ok!";

?>

http://www.bkjia.com/PHPjc/768131.html www.bkjia.com true http://www.bkjia.com/PHPjc/768131.html techarticle database Backup with PHP code can make the management of the site very convenient, we can directly into the background operation to complete the database backup. Key technologies: 1. First to get the ...

