The backup database is an SQL file.
This is an SQL file that backs up all tables in a specified database and can be downloaded.
-
- /****** Back up the database structure ******/
-
- /*
- Function name: table2sql ()
- Function: converts the table structure to SQL
- Function parameter: $ table: name of the table to be extracted
- Return value: return the extracted results, SQL set
- 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 ";
- Return $ tabledump;
- }
-
-
- /****** Back up the database structure and all data ******/
- /*
- Function name: data2sql ()
- Function: converts the table structure and data into SQL statements.
- Function parameter: $ table: name of the table to be extracted
- Return value: return the extracted results, SQL set
- 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 ";
-
- $ 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;
- }
- ?>
-
-
|