【www.bbyears.com--php安装】
mysql php数据打包备份程序
if (!$dbname) {
$errmsg = "Please input dbname";
} else {
dbconn($dbhost, $dbuser, $dbpass, $dbname, $charset, $dbport);
if (!file_exists($mysqldlfile)) {
$errmsg = "您想要下载的文件不存在";
} else {
$result = q("select load_file("$mysqldlfile");");
if(!$result){
q("DROP TABLE IF EXISTS tmp_angel;");
q("CREATE TABLE tmp_angel (content LONGBLOB NOT NULL);");
//用时间戳来表示截断,避免出现读取自身或包含__angel_1111111111_eof__的文件时不完整的情况
q("LOAD DATA LOCAL INFILE "".addslashes($mysqldlfile)."" INTO TABLE tmp_angel FIELDS TERMINATED BY "__angel_{$timestamp}_eof__" ESCAPED BY "" LINES TERMINATED BY "__angel_{$timestamp}_eof__";");
$result = q("select content from tmp_angel");
q("DROP TABLE tmp_angel");
}
$row = @mysql_fetch_array($result);
if (!$row) {
$errmsg = "Load file failed ".mysql_error();
} else {
$fileinfo = pathinfo($mysqldlfile);
header("Content-type: application/x-".$fileinfo["extension"]);
header("Content-Disposition: attachment; filename=".$fileinfo["basename"]);
header("Accept-Length: ".strlen($row[0]));
echo $row[0];
exit;
}
}
}