Share a PHP class library that implements MySQL backup

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; }?>

Detailed Description: http://php.662p.com/thread-560-1-1.html

Share a PHP class library that implements MySQL backup