1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

<?php     
$host="localhost"; //主机名     
$user="root"; //MYSQL用户名     
$password="root"; //密码     
$dbname="dedecmsv4"; //备份的数据库     
 
mysql_connect($host,$user,$password);     
mysql_select_db($dbname);     
 
$q1=mysql_query("show tables");     
while($t=mysql_fetch_array($q1)){     
$table=$t[0];     
$q2=mysql_query("show create table `$table`");     
$sql=mysql_fetch_array($q2);     
$mysql.=$sql['Create Table'].";\r\n\r\n";#DDL     
   
$q3=mysql_query("select * from `$table`");     
while($data=mysql_fetch_assoc($q3))     
{     
$keys=array_keys($data);     
$keys=array_map('addslashes',$keys);     
$keys=join('`,`',$keys);     
$keys="`".$keys."`";     
$vals=array_values($data);     
$vals=array_map('addslashes',$vals);     
$vals=join("','",$vals);     
$vals="'".$vals."'";     
 
$mysql.="insert into `$table`($keys) values($vals);\r\n";     
}     
$mysql.="\r\n";     
 
}     
$filename=date('Ymd')."_".$dbname.".sql"; //文件名为当天的日期     
$fp = fopen($filename,'w');     
fputs($fp,$mysql);     
fclose($fp);     
echo "数据备份成功,生成备份文件".$filename;     
?>

转自:http://www.readlog.cn/?action=show&id=986