a little confusion

[half flung pie]

I'm trying to use mysqldump and have the following PHP code

	$username = "root";
	$password = "password";
	$db = "mydb";
	$backpath = "C:\inetpub\wwwroot\site\backups\\" . $db . "-backup-" . date("Y-m-d-H-i-s") . ".sql";
	$exec = "mysqldump --user={$username} --password={$password} --quick --add-drop-table --add-locks --extended-insert --lock-tables --all {$db} > $backpath";
	exec($exec);

This code apparently does not work though. There are no files saved in that directory after running the code. However, if I run

mysqldump --user=root --password=password --quick --add-drop-table --add-locks --extended-insert --lock-tables --all mydb > C:\inetpub\wwwroot\site\backups\mydb-backup-2010-07-12-14-53-50.sql

in a command prompt, it works just fine. Any ideas why it won't run through PHP?

Also, safe_mode = Off in my php.ini file

[kows]

backslashes are used as an escape character in PHP. PHP things you're trying to save to something like (note that the last slash appears because you escape it):

C:inetpubwwwrootsitebackups\db-backup-Y-m-d-H-i-s.sql

which will obviously not work out too well. escape the backslashes or switch to forward slashes for your path:

$backpath = "C:\\inetpub\\wwwroot\\site\\backups\\" . $db . "-backup-" . date("Y-m-d-H-i-s") . ".sql";
$backpath = "C:/inetpub/wwwroot/site/backups/" . $db . "-backup-" . date("Y-m-d-H-i-s") . ".sql"; 

[half flung pie]

I changed the backpath as you stated, but it still does not work. I have an "echo $exec;" right before the exec($exec); that prints

mysqldump --user=root --password=password --quick --add-drop-table --add-locks --extended-insert --lock-tables --all mydb > C:/inetpub/wwwroot/site/backups/mydb-backup-2010-07-13-09-13-53.sql

But doesn't actually do anything. If I copy that^ and paste it into a command prompt, it works just fine.

[kows]

I copied your script and changed the path accordingly and it worked fine:

    $backpath = "C:/webdev/php/mysqldump/" . $db . "-backup-" . date("Y-m-d-H-i-s") . ".sql";
    $exec = "mysqldump --user={$username} --password={$password} --quick --add-drop-table --add-locks --extended-insert --lock-tables --all {$db} > $backpath";
    exec($exec); 

my guess would be that because you're using IIS, IIS doesn't have permission to write to that directory (or IIS doesn't have the right to execute commands through extensions). I can't really help you out there.

[half flung pie]

I figured it had something to do with IIS. I've seen TONS of examples on how to mysqldump through php, and none of them have worked. So I suppose my question is now "How do I get IIS to execute stuff properly?"