<?php set_time_limit(0); // 备份数据库 $host = "localhost"; // 服务器地址 $user = "root"; //数据库账号 $password = ""; //数据库密码 $dbname = "mysql"; //数据库名称 $charset = 'utf8'; //数据库编码 gbk、utf8 // 以下的代码不要修改了!! if (!mysql_connect($host, $user, $password)) { // 连接mysql数据库 exit('Error: can\'t connect to server.'); } if (!mysql_select_db($dbname)) {// 是否存在该数据库 echo 'Error: no database ' . $dbname; exit; } mysql_query("set names '$charset'"); $mysql = "set charset $charset;\r\n"; $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"; $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"; } } $filename = $dbname . date('Ymjgi') . ".sql"; //存放路径,默认存放到项目最外层 $fp = fopen($filename, 'w'); fputs($fp, $mysql); fclose($fp); echo '<a href="'.$filename .'">'.$filename .'</a>'; ?>