php備份mysql資料庫

標籤：

 

<?php   /*程式功能：mysqlDatabase Backup功能*/ini_set(‘max_execution_time‘,‘0‘);ini_set(‘memory_limit‘,‘1024M‘);//加上這兩行,可以備份大資料,昨晚測了一下公司的一個600M的表,很快就可以備份成功$code_type = ‘gbk‘;header("Content-type:text/html;charset=$code_type");header("Content-disposition:   filename=backup.sql");//所儲存的檔案名稱   header("Content-type:   application/octetstream");   header("Pragma:   no-cache");   header("Expires:   0");   $conn   =   mysql_connect("localhost","root","root");   $db   =   mysql_select_db($dbname,$conn);   mysql_query("set names $code_type");$dbname="test";//資料庫名$flag  = ‘1‘;//1:全部備份,2:只備份表結構,3:只備份資料echo back_dataBase($dbname,$conn,$flag);//備份資料庫//開始備份function back_database($dbname,$conn,$flag=‘1‘){$crlf="\r\n";$str = ‘‘;$now = date(‘Y年m月d日H點i分s秒‘,time());$str .=   "$crlf--$crlf-- 資料庫: `$dbname`$crlf--$crlf-- 匯出日期: `$now`$crlf--$crlf";$str .=   "$crlf--$crlf-- 作者: ****$crlf--$crlf-- QQ: 1019822077$crlf--$crlf";$str .=   "-- blog: http://hi.baidu.com/woaidelphi/blog$crlf--$crlf";$str .=   "SET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";$crlf";$tables       =   mysql_list_tables($dbname,$conn);   $num_tables   =   mysql_numrows($tables);//表的總數 $i   =   0;while($i<$num_tables){//迴圈所有的表     $table =   mysql_tablename($tables,$i);   //備份表結構if($flag==‘1‘ or $flag==‘2‘){$query =   mysql_query("SHOW CREATE TABLE $table");$row   =   mysql_fetch_row($query);$str .=  "-- --------------------------------------------------------$crlf$crlf";$str .=  "--$crlf-- 表的結構 `$table` $crlf--$crlf";$str .=  $row[1].";$crlf--$crlf";}//備份表內容 if($flag==‘1‘ or $flag==‘3‘){$str .= "--$crlf-- 匯出表中的資料 `$table` $crlf--$crlf";$str .=  get_table_content($dbname,$table);$str .= "$crlf$crlf";}$i++;   }return $str;}//得到表中的記錄sql   function   get_table_content($dbname,$table){   $crlf            =   "\r\n";$schema_create   =   "";   $temp            =   "";   $result          =   mysql_db_query($dbname,"SELECT   *   FROM   $table");   $i               =   0;   while($row   =   mysql_fetch_row($result)){   $schema_insert   =   "INSERT   INTO   $table   VALUES   (";   for($j=0;   $j<mysql_num_fields($result);$j++){   if(!isset($row[$j]))   $schema_insert   .=   "   NULL,";   elseif($row[$j]   !=   "")   $schema_insert   .=   "   ‘".addslashes($row[$j])."‘,";   else   $schema_insert   .=   "   ‘‘,";   }   $schema_insert   =   ereg_replace(",$",   "",   $schema_insert);   $schema_insert   .=   ");$crlf";   $temp   =   $temp.$schema_insert   ;   $i++;   }   return   $temp;   }

 

php備份mysql資料庫