发邮件

2. [代码][PHP]代码     跳至 [1] [2] [全屏预览]

[代码] php数据库备份脚本
view sourceprint?01 <?php   

02 // 备份数据库  

03 $host = "localhost";  

04 $user = "root"; //数据库账号  

05 $password = ""; //数据库密码  

06 $dbname = "mysql"; //数据库名称  

07 // 这里的账号、密码、名称都是从页面传过来的  

08 if (!mysql_connect($host, $user, $password)) // 连接mysql数据库  

09     {  

10         echo '数据库连接失败，请核对后再试';  

11     exit;  

12 }   

13 if (!mysql_select_db($dbname)) // 是否存在该数据库  

14     {  

15         echo '不存在数据库:' . $dbname . ',请核对后再试';  

16     exit;  

17 }   

18 mysql_query("set names 'utf8'");  

19 $mysql = "set charset utf8;\r\n";  

20 $q1 = mysql_query("show tables");  

21 while ($t = mysql_fetch_array($q1))  

22 {  

23     $table = $t[0];  

24     $q2 = mysql_query("show create table `$table`");  

25     $sql = mysql_fetch_array($q2);  

26     $mysql .= $sql['Create Table'] . ";\r\n";  

27     $q3 = mysql_query("select * from `$table`");  

28     while ($data = mysql_fetch_assoc($q3))  

29     {  

30         $keys = array_keys($data);  

31         $keys = array_map('addslashes', $keys);  

32         $keys = join('`,`', $keys);  

33         $keys = "`" . $keys . "`";  

34         $vals = array_values($data);  

35         $vals = array_map('addslashes', $vals);  

36         $vals = join("','", $vals);  

37         $vals = "'" . $vals . "'";  

38         $mysql .= "insert into `$table`($keys) values($vals);\r\n";  

39     }   

40 }   

41    

42 $filename = $dbname . date('Ymjgi') . ".sql"; //存放路径，默认存放到项目最外层  

43 $fp = fopen($filename, 'w');  

44 fputs($fp, $mysql);  

45 fclose($fp);  

46 echo "数据备份成功";  

47    

48 ?>