//自己写呗:
/*
假设你的数据库用户名为uuuu密码为pppp数据库为xxxxx
数据库表名为the_table共有3个字段 field1,field2,field3
*/mysql_connect("localhost", "uuuu", "pppp");
mysql_select_db("xxxxx");
$query = "";
$sql = "select * from the_table limit 0, 10000";
$result = mysql_query($sql);
$fp = fopen("00000-10000.sql", "w");
while($dbRow = mysql_fetch_array($result))
{
$query .= "insert into the_table set field1='$dbRow[field1]', field2='$dbRow[field2]', field3='$dbRow[field3]';\n";
}
fputs($fp, $query);
fclose($fp);
//如果目录没权限写入,也可以发送文件形式:
//把$fp = fopen("00000-10000.sql", "w");fclose($fp);去掉header("Content-type: application/octetstream");
header("Content-Disposition: inline; filename=00000-10000.sql");
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Expires: 0');
header('Pragma: public');
echo $query;