Backing up the database as a SQL file

This is a backup of all the tables in the specified database to a SQL file that can be downloaded. /****** backing up the database structure ******/ /* Function name: Table2sql () function function: Convert the structure of a table into SQL Function parameters: $table: The name of the table to extract Return value: Returns the extracted result, SQL collection Function Author: 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; } /****** backing up the database structure and all data ******/ /* Function name: Data2sql () function function: Convert the structure and data of a table into SQL Function parameters: $table: The name of the table to extract Return value: Returns the extracted result, SQL collection Function Author: 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; } ?>