Php backup database sharing, php backup database

Php backup database sharing, php backup database

Php backup database class sharing

<? Php/***** @ name php backup database * @ param string $ DbHost connection host * @ param string $ DbUser username * @ param string $ DbPwd connection password * @ param string $ DbName the name of the database * @ param string $ saveFileName to be backed up, the default file is saved in the current folder, Which is differentiated by date * @ return Null * @ example backupMySqlData ('localhost', 'root', '123', 'yourdbname '); **/function backupMySqlData ($ DbHost, $ DbUser, $ DbPwd, $ DbName, $ saveFileName = '') {header (" Content-type: t Ext/html; charset = UTF-8 "); error_reporting (0); set_time_limit (0); echo 'data backup, please wait ...... <br/> '; $ 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 the variable $ isDropInfo = ''; $ insertSQL =''; $ row = array (); $ tables = array (); $ tableStructure = array (); $ fileName = ($ saveFile Name? $ 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 the statement foreach ($ tables as $ val) for creating all tables) {$ res = mysql_query ("show create table $ val", $ link); $ row = mysql_fetch_row ($ res); $ isDropInfo = "drop table if exists '". $ val. "'; \ r \ n"; $ ta BleStructure = $ 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 while ($ row = mysql_fetch_row ($ res) {$ sqlStr = "insert '". $ val. "'values ("; foreach ($ row as $ v) {$ sqlStr. = "'$ V'," ;}// remove the last comma $ sqlStr = substr ($ sq LStr, 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');?>

The above is all the content of this article. I hope you will like it.