Trying to get a mysql dump from php script---empty file created

[calabiyau]

I am doing this right now on my own server at home, but would like this to be portable to my host as well.  I am executing the code below and it brings up the mysql dump screen for a flash and creates the file, but it is empty.  The connection information is correct.  Can anyone see what I am doing wrong here?

 

include('../connections.php');

$backupFile = $mydtb . date("Y-m-d-H-i-s") . '.dump';
$command = "mysqldump --host ".$server." -u ".$user." --password=".$password." ".$mydtb." > ".$backupFile;
echo $command;
system($command);

[el1986]

Im having exactly the same problem, have you got a solution yet?

[btherl]

What exactly do you see for a flash?  And why do you only see it for a flash?  Is this via web server or command line?

 

Second question:  If you run $command manually (exactly as it is displayed by the script when echoed), does it work?

[el1986]

1. When i run the web interface i don't see anything happening apart from the priniting out of $command, but an empty file is created.

 

2. Because im running it from local computer when i go to the bin folder in mysql there is mysqldump.exe when i try to run thisthe command line flashes up then closes. i don't know why, not sure if thats what it's meant to do!

 

3. I don't know how to run it manually so can't check if it works