php的dump不起作用,使用PHP脚本：为什么mysqldump不会转储sql文件？

Hye,我是PHP的新手,并尝试使用php脚本使用mysqldump.

我已经尝试使用命令,转储过程成功.情况是,当我尝试使用本地计算机进行转储时,转储成功.但是当代码传输到服务器时,mysqldump不起作用.我已经尝试了几乎与mysqldump主题相关的解决方案,但它仍然不起作用.我希望有人能指导我. TQ

/*-----------------------------------------------

MYSQLDUMP FOR SERVER

------------------------------------------*/

$dbhost = "*****";

$dbuser = "*****";

$dbpass = "*****";

$dbname = "*****";

//set date today

$today=date("d-m-Y");

//set file name

$filename = "leave_".$today.".sql";

//MYSQLDUMP

//For Server

$command = sprintf("/usr/bin/mysqldump --opt -h%s -u%s -p%s %s >/var/www/html/leave/leave/backup/%s",

//for local

//$command = sprintf("c:\AppServ\MySQL\bin\mysqldump --opt -h%s -u%s -p%s %s > %s",

$dbhost,

$dbuser,

$dbpass,

$dbname,

$filename

);

system($command);

/*-------------------------------------------------------------

TO SAVE FILE SQL INTO LOCAL

---------------------------------------------------------------*/

$file = "leave_".$today.".sql";

if(!$file)

{

// File doesn't exist, output error

die('File not found');

}

else

{

// Set headers to ask user where to save file.

header('Pragma: anytextexeptno-cache', true);

header("Pragma: public");

header("Expires: 0");

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header("Cache-Control: private", false);

header("Content-Type: text/plain");

header("Content-Disposition: attachment; filename=$file");

// Read the file from disk

readfile($file);

}

?>