php++数据库备份,php实现数据库备份

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

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

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

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="

备份数据库成功！

.";

}

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 "

数据库还原成功

";

echo "";

}

} ?>