Just want to study how to back up the database, share a PHP implementation of MySQL backup class library
<?php/****** backing up the database structure ******//**** just want to study how to back up the database, share a PHP implementation of MySQL backup class library ********//* Function name: Table2sql () function function: Put the table to a SQL function parameter: $table: Returns the value of the table name to extract: Returns the extracted result, SQL aggregate function Heiyeluren */function Table2sql ($table ) {Global $db; $tabledump = "DROP TABLE IF EXISTS $table; \ n"; $createtable = $db->query ("SHOW CREATE TABLE $table"); $create = $db->fetch_row ($createtable); $tabledump. = $create [1]. "; N\n "; return $tabledump; /****** back up the database structure and all data ******//* Function name: Data2sql () function: Convert table structure and data into SQL function parameters: $table: The name of the table to extract Return value: Returns the extracted result, SQL aggregate function Heiyeluren */function Data2sql ($table) {global $db; $tabledump = "DROP TABLE IF EXISTS $table; \ n"; $createtable = $db->query ("SHOW CREATE TABLE $table"); $create = $db->fetch_row ($createtable); $tabledump. = $create [1]. "; N\n "; $rows = $db->query("SELECT * from $table"); $numfields = $db->num_fields ($rows); $numrows = $db->num_rows ($rows); while ($row = $db->fetch_row ($rows)) {$comma = ""; $tabledump. = "INSERT into $table VALUES ("; for ($i = 0; $i < $numfields; $i + +) {$tabledump. = $comma. "'". Mysql_escape_string ($row [$i]). "'"; $comma = ","; } $tabledump. = "); \ n"; } $tabledump. = "\ n"; return $tabledump; }?>
- Related articles recommended:
- Teaches you to install the Phpredis module under Windows
- Code to convert txt files to htm in PHP
- PHP automatic removal of MySQL dead connection (Sleep) method
- This article from: Hobby Linux Technology Network
- This article link: http://www.ahlinux.com/php/9088.html
Share a PHP class library that implements MySQL backup