php // $dumpfilename目录要有可写权限 $dbhost = 'localhost';$dbuser = 'root';$dbpwd = '123456';$dbname = 'a'; $filename = $dbname . '_mysql_data_backup_' . date('ymdhis) . '.sql';$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, 'rb');echo fread($hd, filesize($dumpfilename));fclose($hd); ?>
以上就介绍了php使用外部命令导出数据库，备份到服务器并下载到本地，包括了方面的内容，希望对php教程有兴趣的朋友有所帮助。