沧海一粟

一个比较好用的php备份mysql数据库

Mon, 27 Aug 2007 09:30:26 +0000

include "inc/admincheckLogin.php";
include "../inc/config.php";
$PWARRAY=mysql_fetch_array(mysql_query("SELECT * FROM shm_siteadmin WHERE user='".$power_user."'"));
$name=$PWARRAY[name];$right=$PWARRAY[adright];$state=$PWARRAY[state];
function get_image_size($pix_path,$w,$h){
$size=getimagesize($pix_path);
$ow=$size[1];
$oh=$size[0];
$w=($oh>$h and $ow<=$w and $oh>$ow)?($ow*$h/$oh):$w;
$h=($oh<=$h and $ow>$w and $oh<$ow)?($oh*$w/$ow):$h;
$w=($oh>$h and $ow>$w and $oh>=$ow)?($ow*$h/$oh):$w;
$h=($oh>$h and $ow>$w and $oh<=$ow)?($oh*$w/$ow):$h;
$b_size[1]=$w;
$b_size[0]=$h;
if($oh<=$h and $ow<=$w){
$b_size[1]=$ow;
   $b_size[0]=$oh;
}
return $b_size;
}
DEFINE ("DEBUG", 0);
?>
function create_table_sql_string($tablename){
  $sql_string = "CREATE TABLE $tablename";
  $result = mysql_query("DESCRIBE $tablename");
  if (DEBUG) echo "field_info\n\n";
  $field_string = "";
  while ($field_info = mysql_fetch_array($result)) {
    $field_name = $field_info[0];
    $field_type = $field_info[1];
    $field_not_null = ($field_info[2] == "YES") ? "" : " NOT NULL";
    $field_default = ($field_info[4] == NULL) ? "" : sprintf(" default '%s'", $field_info[4]);;
    $field_auto_increment = ($field_info[5] == NULL) ? "" : sprintf(" %s", $field_info[5]);

    $field_string = sprintf("%s, %s %s%s%s%s", $field_string, $field_name, $field_type, $field_not_null, $field_auto_increment, $field_default);
  }

  $result = mysql_query("SHOW INDEX FROM $tablename");
  if (DEBUG) echo "\nindex_info\n\n";
  $index_string = "";
  while ($index_info = mysql_fetch_array($result)) {

    $index_name = $index_info[2];
    $index_unique = $index_info[1];
    $index_field_name = $index_info[4];
    $index_type = $index_info[10];

    if ($index_name == "PRIMARY") $index_name = "PRIMARY KEY";
    if ($index_unique == "1" && $index_type != "FULLTEXT") $index_name = sprintf("KEY %s", $index_name);
    if ($index_unique == "0" && $index_name != "PRIMARY KEY") $index_name = sprintf("UNIQUE KEY %s", $index_name);
    if ($index_type == "FULLTEXT") $index_name = sprintf("FULLTEXT KEY %s", $index_name);
    $index_string = sprintf("%s, %s (%s)", $index_string, $index_name, $index_field_name);
  }

  $result = mysql_query("SHOW TABLE STATUS");
  if (DEBUG) echo "\nstatus_info\n\n";
  while ($status_info = mysql_fetch_array($result)) {
    for ($i = 0; $i < count($status_info); $i++) {
      if (DEBUG) echo "$i: $status_info[$i]\n";
      if ($status_info[0] == $tablename) $table_type = sprintf("TYPE=%s", $status_info[1]);
    }
  }
  $field_string = substr($field_string, 2);
  $field_string = sprintf("%s%s", $field_string, $index_string);
  $field_string = sprintf("(%s)", $field_string);
  $sql_string = sprintf("%s %s %s", $sql_string, $field_string, $table_type);
  return $sql_string.";";
}

function create_data_sql_string($tablename)
{
  $sql_string = "";
  $result = mysql_query("SELECT * FROM $tablename");
  while ($row = mysql_fetch_row($result)) {
   $data_string = "";
    for ($i = 0; $i < mysql_num_fields($result); $i++) {
      $data_string = sprintf("%s, '%s'", $data_string, mysql_escape_string($row[$i]));
    }
    $data_string = substr($data_string, 2);
    $data_string = sprintf("VALUES (%s)", $data_string).";";
    $sql_string = sprintf("%sINSERT INTO %s %s\n", $sql_string, $tablename, $data_string);
  }
  return $sql_string;
}
?>
if(isset($act) and $act=="bakup"){
$dir=date("Y_m_d");
if(!file_exists("data/".$dir)) $r=mkdir("data/".$dir,0700);
for($i=0;$i<12;$i++){
   $table = $GLOBALS["ch".$i];
   if($table!=""){
   if($bukcon=="all"){
   $datable = create_table_sql_string($table);
$data = create_data_sql_string($table);
       $txt=$datable."\n".$data;
     }
     if($bukcon=="record") $txt = create_data_sql_string($table);
     if($bukcon=="struct") $txt = create_table_sql_string($table);
   $filename=$table."_".$bukcon.date('_H_m').'_'.'nb315'.'.sql';
$fp=fopen("data/".$dir."/".$filename,"w+");
if(fputs($fp,$txt))$out="数据表".$table."已成功备份在 data/$dir/目录下--文件名是$filename"."\\n\\n".$out;
}
}
echo "";
}
?>
function check_dir($dir){
   $temp=opendir($dir);
   while($tempfile=readdir($temp)){
   if(($tempfile!=".")&&($tempfile!="..")&&($tempfile!="")){
       return $tempfile;
    }
   }
   closedir($temp);
   return 0;
}

if(isset($button) and $button=="删除"){
for($i=0;$i<$filelength;$i++){
   $list= $GLOBALS["f".$i];
   if($list!=""){
     if(!is_dir($dir.$list)) unlink($dir.$list);
   else{
     if(check_dir($dir.$list)) echo "";
     else rmdir($dir.$list);
   }
   }
   }
}
?>

警告：本系统将对数据表结构和数据记录完全备份,但不对数据库之外的任何文件进行备份,请自行备份文件。

备份文件自动保存在服务器data目录下，请自行保存在本地电脑上，以防止意外。

选择“数据结构＋数据记录”，将保存数据库所有内容，选择“数据结构”或者“数据记录”，将只保存选择的部分。

请定期备份！

     $opendir=opendir($dir);
      $num=0;
      while($file_name=readdir($opendir)){
   if(($file_name!=".") and ($file_name!="..")){
         $temp= "";
         if(!is_dir($dir.$file_name)) $temp=$temp."";
         else $temp=$temp."";
         $num=$num+1;
         echo $temp;
        }
      }
    closedir($opendir);
    clearstatcache();
    if($num==0) echo "";
     ?>

全选	文件或文件夹名
	$file_name
$file_name
此目录是空的，没有文件
>

style="FONT-SIZE: 11px; FONT-FAMILY: Tahoma, Verdana, Arial">Powered by style="COLOR: #000000" href="http://www.foodmate.com/"
target=_blank>foodmate.com © 2001-2008, foodmate.com
Inc.

[评论] 一个比较好用的php备份mysql数据库

Tue, 22 Apr 2008 04:38:34 +0000

靠代码不全的都发

[评论] 一个比较好用的php备份mysql数据库

Mon, 01 Dec 2008 07:37:33 +0000

我日，整理好了再发不行啊