Php backup database class sharing _ PHP Tutorial

Php backup database class sharing. Php backup database sharing 12345678910111213141516171819202122232425262728293031323334353637383940414243444 php backup database sharing

Php backup database class sharing

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84

/** * * @ Name php back up the database * @ Param string $ DbHost connects to the host * @ Param string $ DbUser user name * @ Param string $ DbPwd connection password * @ Param string $ DbName the database to be backed up * @ Param string $ saveFileName indicates the name of the file to be saved. by default, the file is saved in the current folder, which is differentiated by date. * @ Return Null * @ Example backupMySqlData ('localhost', 'root', '000000', 'yourdbname '); * */ Function backupMySqlData ($ DbHost, $ DbUser, $ DbPwd, $ DbName, $ saveFileName = '') { Header ("Content-type: text/html; charset = utf-8 "); Error_reporting (0 ); Set_time_limit (0 ); Echo 'data backup in progress. please wait ...... '; $ Link = mysql_connect ($ DbHost, $ DbUser, $ DbPwd) or die ('database connection failed: '. mysql_error ()); Mysql_select_db ($ DbName) or die ('database connection failed: '. mysql_error ()); Mysql_query ('set names utf8 '); // Declare variables $ IsDropInfo = ''; $ InsertSQL = ''; $ Row = array (); $ Tables = array (); $ TableStructure = array (); $ FileName = ($ saveFileName? $ SaveFileName: 'MySQL _ data_bakeup _ '). date ('ymdhis'). '. SQL '; // Enumerate all tables in the database $ Res = mysql_query ("show tables from $ DbName "); While ($ row = mysql_fetch_row ($ res )){ $ Tables [] = $ row [0]; } Mysql_free_result ($ res ); // Enumerate creation statements for all tables Foreach ($ tables as $ val ){ $ Res = mysql_query ("show create table $ val", $ link ); $ Row = mysql_fetch_row ($ res ); $ IsDropInfo = "drop table if exists" '. $ val. "'; \ r \ n "; $ TableStructure = $ isDropInfo. $ row [1]. "; \ r \ n "; File_put_contents ($ fileName, $ tableStructure, FILE_APPEND ); Mysql_free_result ($ res ); } // Enumerate the INSERT statements of all tables Foreach ($ tables as $ val ){ $ Res = mysql_query ("select * from $ val "); // Insert is not executed for tables without data While ($ row = mysql_fetch_row ($ res )){ $ SqlStr = "insert into" '. $ val. "'values ("; Foreach ($ row as $ v ){ $ SqlStr. = "'$ V ',"; } // Remove the last comma $ SqlStr = substr ($ sqlStr, 0, strlen ($ sqlStr)-1 ); $ SqlStr. = "); \ r \ n "; File_put_contents ($ fileName, $ sqlStr, FILE_APPEND ); } Mysql_free_result ($ res ); } Echo 'data backup successful! '; } // Call this method BackupMySqlData ('localhost', 'root', '123', 'youdbname '); ?>

Sort php backup database class sharing 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 4...