mysql mysql数据打包备份程序
 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;
   }
  }
 }

本文地址：http://www.phprm.com/frame/php1004950.html

转载随意，但请附上文章地址:-)