php实现数据库备份

这是我2010-12-08 21:38 写的了，本来是写在百度空间的，想想还是放在这里比较好。

 

花了不少时间，网站终于搞定了，通过这次实践操作学会了不少知识，拿来供大家分享一下。

这次网站我主要负责写数据备份和音乐在线播放模块，数据备份代码贴出来如下：

<?php
  class DataBackUp
   {
    var $HOST;
       var $USERNAME;
       var $PASSWORD;
       var $DATABASE;
    var $con;
    var $result;
    var $tabledump;

//连接数据库

    function DataBackUp($host,$username,$password,$database)
    {
           
            $this->HOST= $host;
            $this->USERNAME=$username;
            $this->PASSWORD=$password;
            $this->DATABASE=$database;
   $this->con = mysql_connect("$this->HOST","$this->USERNAME","$this->PASSWORD")or die(mysql_error());
   mysql_select_db("$this->DATABASE",$this->con)or die(mysql_error());
   mysql_query("SET NAMES 'utf8'");
    }

   //获得数据库的表名
      function get_table_name($database)
   {
        $result=mysql_list_tables($database);
        $table_name = array();
        for ($i = 0; $i < @mysql_num_rows($result); $i++)
  {
          $table_name[$i]=mysql_tablename($result, $i);
  }
  return $table_name;

     }

//获得数据库表的数量

  function get_table_nums($database)
    {
           $result=mysql_list_tables($database);
     return @mysql_num_rows($result);
    }

 //获得相应表的内容

       function get_table_fields($table_name)
    {
     $createtable=mysql_query("SHOW CREATE TABLE $table_name");
           $create=mysql_fetch_row($createtable);
           $tabledump ="DROP TABLE IF EXISTS $table_name;/n";
           $tabledump .= $create[1].";/n/n";
           return $tabledump;
    }

//获得数据库里的具体内容，第一次
       function get_insert($table_insert_name)
    {
       $rows = mysql_query("SELECT * FROM $table_insert_name") or die(mysql_error());
   if ( !$rows )
  {
     die(mysql_error());
  }
      $numfields = mysql_num_fields($rows);
        $numrows = mysql_num_rows($rows);  //echo $numrows;
       while ($row = mysql_fetch_row($rows))
    {
           $comma = "";
           $this->tabledump .= "INSERT INTO $table_insert_name VALUES(";
           for($i = 0; $i < $numfields; $i++)
        {
             $this->tabledump .= $comma."'".mysql_escape_string($row[$i])."'";
             $comma = ",";
           }
             $this->tabledump .= ");/n";
    
       }  
          
        return $this->tabledump;
       }

//这里我要强调一下，第一次写的时候将 $table_insert=$this->get_insert($table_name[$i]);
//写成了 $table_insert  . =$this->get_insert($table_name[$i]);多加了一个点，结果导致只能备份一部分数据

     function get_string($database_name,$file_path_name)
  {
       
     
        $table_name=$this->get_table_name($database_name);
  $table_num = $this->get_table_nums($database_name);
     $table_insert="";
  $table_fields="";
        for($i=0;$i < $table_num;$i++)
   {
           $table_insert=$this->get_insert($table_name[$i]);
           $table_fields.=$this->get_table_fields($table_name[$i]);
         }
   $content = $table_fields.$table_insert;
        $write_status=$this->write_file($file_path_name,$content);
        msg($write_status);
      }

 //将获得的数据库内容写到文件里

      function write_file($file_path,$file_contents)
   {
       if(@!$fp=fopen($file_path,'w'))
  {
        $status="This File Could Not Open Or Read.";
        }else{
        flock($fp,3);
        fwrite($fp,$file_contents);
        fclose($fp);
        $status="<h4><font color=/"red/">备份数据库成功！</font></h4>.";
        }
        return $status;
     }
     
  //还原数据库
  function recover_data($data)
    {
         
           $handle = fopen($data, "r");
           $contents = fread($handle, filesize($data));
           fclose($handle);
     $contents = explode(';', $contents );
           foreach ($contents as $sql)
     {
             if (!empty($sql)) {
              mysql_query($sql);
     }
     }

     echo "<h3><font color=/"red/">数据库还原成功</font></h3>";
     echo "<meta http-equiv=/"refresh/" content=/"1000;URL=index.php?action=databack&ts=list/">";
    }

   }
?>