mysqldump

[kante]

I'm trying this script under IIS 5.1 with php 5 and mysql latest stable release :

<?php
ob_start();
exec("mysqldump -u root -password=123456 mydatabase ");
//if i use system() instead of exec() it will warining me Unable to Fork??? (seems it doesn't find the program)
//so i tryed to update environment Variable PATH with Mysldump location
//but nothing changed

$dump = ob_get_contents();
echo $dump;
ob_end_clean();
//The database dump now exists in the $dump variable... write it to a file using...
$fp = fopen("dump.sql", "w");
fputs($fp, $dump);
fclose($fp);
?>

it seems correct but in dump.sql i find a an empty file.... :bemused:
can u help me pls?

[devinemke]

the [man]exec[/man] function is not going to to return the contents of the dump. you are also not using the correct mysqldump syntax:

exec('/path/to/mysqldump --host=[host] --user=[user] --password=[password] [dbname] >/path/to/output.sql');

just fill in the correct paths and credentials. this will write to dump to /path/to/output.sql