如何用PHP脚本导出MySQL数据库

Question

我需要一个脚本，当我打开script.php页面，例如，导出我一个数据库从MySQL到SQL文档，我不知道如何在PHP中做到这一点，有人可以帮助我吗?

编辑代码:

<?php
$dbhost   = "localhost";
$dbuser   = "root";
$dbpwd    = "";
$dbname   = "activmanagement";
$dumpfile = $dbname . "_" . date("Y-m-d_H-i-s") . ".sql";
passthru("D:/wamp/bin/mysql/mysql5.6.17/bin/mysqldump --opt --host=$dbhost --user=$dbuser --password=$dbpwd $dbname > $dumpfile");
// report - disable with // if not needed
// must look like "-- Dump completed on ..." 
echo "$dumpfile "; passthru("tail -1 $dumpfile");
?>

这条线

:

passthru("D:/wamp/bin/mysql/mysql5.6.17/bin/mysqldump --opt --host=$dbhost --user=$dbuser --password=$dbpwd $dbname > $dumpfile");

Answer 1

参考PHP - exec() vs system() vs passthru()。你只需要这样的东西

---

<?php
    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = '';
    $dbname   = 'activmanagement';
    $sql_backup_file = $dbname . date("Y-m-d-H-i-s") . '.gz';
    $dump = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $sql_backup_file";
    system($dump);
?>