problem with mysqldump

jasongonella

How's it going?

I'm trying to use the following function to return a string with a dumped database in it.

I get an error with this function when executing the shell command ('system' function call):

'Warning: Unable to fork [mysqldump -u -p database_name > database_backup.sql] '

...and I was careful to make sure I put in my real database name.

Also, I'm running locally (i.e. on windows) without a password which is why this is set to "".

Does anyone know what I'm doing wrong please?

function mysql_dump_data($database_name = "my_database_name")

{

$user_name = "localhost";
$password = "";

$sql_dump = "mysqldump -u$user_name -p$password $database_name > database_backup.sql";

$sql_dump_result = system($sql_dump);

echo "<br>\n sql_dump_result is " . $sql_dump_result;

return $sql_dump;
}

Many thanks if you can assist,

Regards,

Jason

Anon

I'm not sure if this is the problem or not, but if you don't have a password then don't use the -p switch as that will cause a password prompt if no password is provided.

Anon

Try this:

$sql_dump = "mysqldump -u $user_name $database_name > database_backup.sql";

this should work

Happy diwi

jasongonella

Thanks for trying guys - but still receiving same error message?????????

Regards,

Jason

Anon

Hi,

What system do you use Windows IIS or are you on a Linux like machine.

If you use Windows IIS then
Exec, system, will only work on NT, IIS 4 if you set php to run as a cgi. Otherwise you get a forking error.

Hope this helps

Anon

If not try this:

function mysql_dump_data($database_name = "GereDatacep")

{

$user_name = "localhost";

$sql_dump = 'mysqldump.exe -u '.$user_name.' '.$database_name;
echo $sql_dump;

$sql_dump_result = system($sql_dump);

echo "<br>\n sql_dump_result is " . $sql_dump_result;

return $sql_dump;
}

tullys

The bugs have been worked out in PHP 4.0.6 . I had the same problems with Windows, but they were solved with the upgrade.
Download the windows self installer and enjoy. http://www.php.net/