PHP implements MySQL database backup class

The example in this article describes how PHP implements the MySQL database backup class. Share it with everyone for your reference. The specific analysis is as follows: This is a very simple class file that uses php to back up mysql database. We only need to simply configure the connection address, user name and database.

php backup database class sharing

'; $link = mysql_connect($DbHost, $DbUser, $DbPwd) or die('数据库连接失败: ' . mysql_error()); mysql_select_db($DbName) or die('数据库连接失败: ' . mysql_error()); mysql_query('set names utf8'); // 声明变量 $isDropInfo = ''; $insertSQL = ''; $row = array(); $tables = array(); $tableStructure = array(); $fileName = ($saveFileName ? $saveFileName : 'MySQL_data_bakeup_') . date('YmdHis') . '.sql'; // 枚举该数据库所有的表 $res = mysql_query("SHOW TABLES FROM $DbName"); while ($row = mysql_fetch_row($res)) { $tables[] = $row[0]; } mysql_free_result($res); // 枚举所有表的创建语句 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); } // 枚举所有表的INSERT语句 foreach ($tables as $val) { $res = mysql_query("select * from $val"); // 没有数据的表不执行insert while ($row = mysql_fetch_row($res)) { $sqlStr = "INSERT INTO `".$val."` VALUES ("; foreach($row as $v){ $sqlStr .= "'$v',"; } //去掉最后一个逗号 $sqlStr = substr($sqlStr, 0, strlen($sqlStr) - 1); $sqlStr .= ");\r\n"; file_put_contents($fileName, $sqlStr, FILE_APPEND); } mysql_free_result($res); } echo '数据备份成功！'; } 　　 // 调用此方法 backupMySqlData('localhost', 'root', '123456', 'YouDbName'); ?>

Summary: The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

phpHow to convert numbers into Chinese characters

PHP Mysql jQuery implements password retrieval Function

php method to dynamically create html code based on array

The above is the detailed content of PHP implements MySQL database backup class. For more information, please follow other related articles on the PHP Chinese website!