聊聊php如何快速备份mysql数据库

对于一个数据库开发者来说，牢固扎实的基础是十分重要的，golang学习网就来带大家一点点的掌握基础知识点。今天本篇文章带大家了解《聊聊php如何快速备份mysql数据库》，主要介绍了MySQL、PHP，希望对大家的知识积累有所帮助，快点收藏起来吧，否则需要时就找不到了！

<?php &nbsp; 
/*程序功能：mysql数据库备份功能*/
ini_set(&#39;max_execution_time&#39;,&#39;0&#39;);
ini_set(&#39;memory_limit&#39;,&#39;1024M&#39;);//加上这两行,可以备份大数据,昨晚测了一下公司的一个600M的表,很快就可以备份成功
$code_type = &#39;gbk&#39;;
header("Content-type:text/html;charset=$code_type");
header("Content-disposition: &nbsp; filename=backup.sql");//所保存的文件名 &nbsp; 
header("Content-type: &nbsp; application/octetstream"); &nbsp; 
header("Pragma: &nbsp; no-cache"); &nbsp; 
header("Expires: &nbsp; 0"); &nbsp; 
$conn &nbsp; = &nbsp; mysql_connect("localhost","root","root"); &nbsp; 
$db &nbsp; = &nbsp; mysql_select_db($dbname,$conn); &nbsp; 
mysql_query("set names $code_type");
$dbname="test";//数据库名
$flag &nbsp;= &#39;1&#39;;//1:全部备份,2:只备份表结构,3:只备份数据
echo back_database($dbname,$conn,$flag);//备份数据库



//开始备份
function back_database($dbname,$conn,$flag=&#39;1&#39;){
$crlf="rn";
$str = &#39;&#39;;
$now = date(&#39;Y年m月d日H点i分s秒&#39;,time());
$str .= &nbsp; "$crlf--$crlf-- 数据库: `$dbname`$crlf--$crlf-- 导出日期: `$now`$crlf--$crlf";
$str .= &nbsp; "$crlf--$crlf-- 作者: ****$crlf--$crlf-- QQ: 1019822077$crlf--$crlf";
$str .= &nbsp; "-- blog: https://infoflow.baidu.com
$str .= &nbsp; "SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";$crlf";
$tables &nbsp; &nbsp; &nbsp; = &nbsp; mysql_list_tables($dbname,$conn); &nbsp; 
$num_tables &nbsp; = &nbsp; mysql_numrows($tables);//表的总数 
$i &nbsp; = &nbsp; 0;
while($i<$num_tables){//循环所有的表 &nbsp; &nbsp; 
$table = &nbsp; mysql_tablename($tables,$i); &nbsp; 
//备份表结构
if($flag==&#39;1&#39; or $flag==&#39;2&#39;){
$query = &nbsp; mysql_query("SHOW CREATE TABLE $table");
$row &nbsp; = &nbsp; mysql_fetch_row($query);
$str .= &nbsp;"-- --------------------------------------------------------$crlf$crlf";
$str .= &nbsp;"--$crlf-- 表的结构 `$table` $crlf--$crlf";
$str .= &nbsp;$row[1].";$crlf--$crlf";
}
//备份表内容 
if($flag==&#39;1&#39; or $flag==&#39;3&#39;){
$str .= "--$crlf-- 导出表中的数据 `$table` $crlf--$crlf";
$str .= &nbsp;get_table_content($dbname,$table);
$str .= "$crlf$crlf";
}
$i++; &nbsp; 
}
return $str;
}
//得到表中的记录sql &nbsp; 
function &nbsp; get_table_content($dbname,$table){ &nbsp; 
$crlf &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= &nbsp; "rn";
$schema_create &nbsp; = &nbsp; ""; &nbsp; 
$temp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= &nbsp; ""; &nbsp; 
$result &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= &nbsp; mysql_db_query($dbname,"SELECT &nbsp; * &nbsp; FROM &nbsp; $table"); &nbsp; 
$i &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = &nbsp; 0; &nbsp; 
while($row &nbsp; = &nbsp; mysql_fetch_row($result)){ &nbsp; 
$schema_insert &nbsp; = &nbsp; "INSERT &nbsp; INTO &nbsp; $table &nbsp; VALUES &nbsp; ("; &nbsp; 
for($j=0; &nbsp; $j<mysql_num_fields($result);$j++){ &nbsp; 
if(!isset($row[$j])) &nbsp; 
$schema_insert &nbsp; .= &nbsp; " &nbsp; NULL,"; &nbsp; 
elseif($row[$j] &nbsp; != &nbsp; "") &nbsp; 
$schema_insert &nbsp; .= &nbsp; " &nbsp; &#39;".addslashes($row[$j])."&#39;,"; &nbsp; 
else &nbsp; 
$schema_insert &nbsp; .= &nbsp; " &nbsp; &#39;&#39;,"; &nbsp; 
} &nbsp; 
$schema_insert &nbsp; = &nbsp; ereg_replace(",$", &nbsp; "", &nbsp; $schema_insert); &nbsp; 
$schema_insert &nbsp; .= &nbsp; ");$crlf"; &nbsp; 
$temp &nbsp; = &nbsp; $temp.$schema_insert &nbsp; ; &nbsp; 
$i++; &nbsp; 
} &nbsp; 
return &nbsp; $temp; &nbsp; 
}

今天带大家了解了MySQL、PHP的相关知识，希望对你有所帮助；关于数据库的技术知识我们会一点点深入介绍，欢迎大家关注golang学习网公众号，一起学习编程~