php定时备份数据库数据，导出sql文件

1. <?php
2. //无论客户端是否关闭浏览器，下面的代码都将得到执行。
3. ignore_user_abort( true);set_time_limit( 0);
4. //function write_txt(){
5. ini_set( "max_execution_time", "180"); //避免数据量过大，导出不全的情况出现。
7. $host= "127.0.0.1"; //数据库地址
8. $dbname= "apiadmin"; //这里配置数据库名
9. $username= "root"; //用户名
10. $passw= "root"; //这里配置密码
12. $filename=date( "Y-m-d_H-i-s"). "-".$dbname. ".sql";
13. header( "Content-disposition:filename=".$filename); //所保存的文件名
14. header( "Content-type:application/octetstream");
15. header( "Pragma:no-cache");
16. header( "Expires:0");
17. //备份数据
18. $i = 0;
19. $crlf= "\r\n";
20. global $dbconn;
21. $dbconn = mysql_connect($host,$username,$passw); //数据库主机，用户名，密码
22. $db = mysql_select_db($dbname,$dbconn);
23. mysql_query( "SET NAMES 'utf8'");
24. $tables =mysql_list_tables($dbname,$dbconn);
25. $num_tables = @mysql_numrows($tables);
26. print "-- filename=".$filename;
27. while($i < $num_tables)
28. {
29. $table=mysql_tablename($tables,$i);
30. print $crlf;
31. echo get_table_structure($dbname, $table, $crlf). ";$crlf$crlf";
32. //echo get_table_def($dbname, $table, $crlf).";$crlf$crlf";
33. echo get_table_content($dbname, $table, $crlf);
34. $i++;
35. }
36. //}
37. function get_table_structure($db,$table,$crlf)
38. {
39. global $drop;
40. $schema_create = "";
41. if(! empty($drop)){ $schema_create .= "DROP TABLE IF EXISTS `$table`;$crlf";}
42. $result =mysql_db_query($db, "SHOW CREATE TABLE $table");
43. $row=mysql_fetch_array($result);
44. $schema_create .= $crlf. "-- ".$row[ 0].$crlf;
45. $schema_create .= $row[ 1].$crlf;
46. Return $schema_create;
47. }
50. //获得表内容
51. function get_table_content($db, $table, $crlf)
52. {
53. $schema_create = "";
54. $temp = "";
55. $result = mysql_db_query($db, "SELECT * FROM $table");
56. $i = 0;
57. while($row = mysql_fetch_row($result))
58. {
59. $schema_insert = "INSERT INTO `$table` VALUES (";
60. for($j= 0; $j<mysql_num_fields($result);$j++)
61. {
62. if(! isset($row[$j]))
63. $schema_insert .= " NULL,";
64. elseif($row[$j] != "")
65. $schema_insert .= " '".addslashes($row[$j]). "',";
66. else
67. $schema_insert .= " '',";
68. }
69. $schema_insert = ereg_replace( ",$", "",$schema_insert);
70. $schema_insert .= ");$crlf";
71. $temp = $temp.$schema_insert ;
72. $i++;
73. }
74. return $temp;
75. }
77. //usleep适用于php5.0以上，定时
78. function do_cron(){usleep( 1);write_txt();}
80. while( 1){do_cron();}
81. ?>
82.