<span><?<span>php
</span><span>//</span><span> $dumpFileName目录要有可写权限</span>
<span>$DbHost</span> = 'localhost'<span>;
</span><span>$DbUser</span> = 'root'<span>;
</span><span>$DbPwd</span> = '123456'<span>;
</span><span>$DbName</span> = 'a'<span>;
</span><span>$fileName</span> = <span>$DbName</span> . '_MySQL_data_backup_' . <span>date</span>('YmdHis) . '.sql'<span>;
$dumpFileName= "/var/$fileName";
header("Content-Disposition: attachment; filename=" . $fileName);
header("Content-type: application/octet-stream");
header("Pragma:no-cache");
header("Expires:0");
echo `mysqldump -h $DbHost -u$DbUser -p$DbPwd $DbName > $dumpFileName`;
$hd = fopen($dumpFileName, </span>'rb'<span>);
echo fread($hd, filesize($dumpFileName));
fclose($hd);
?></span></span>
以上就介绍了PHP使用外部命令导出数据库，备份到服务器并下载到本地，包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。
PHP怎么学习？PHP怎么入门？PHP在哪学？PHP怎么学才快？不用担心，这里为大家提供了PHP速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
673
收藏
