shell executions w/o response

[groovepapa]

is there a way to make php fire off a shell command and NOT wait for the response? I'm interested in this command...

$restoreSQL = "RESTORE TABLE $currentTable FROM '$backupDir/$currentDB'";
`/usr/local/mysql/bin/mysql -p<censored> $currentDB -e "$restoreSQL" &`;

or, since I just need a SQL query to run on a MySQL server and NOT wait for the response, is there a MySQL function in PHP that will do that?

tia...

[tsinka]

Hi,

try something like this:

$restoreSQL = "RESTORE TABLE $currentTable FROM '$backupDir/$currentDB'";
system("/path/to/nohup /usr/local/mysql/bin/mysql -u<user> -p<censored> $currentDB -e \"$restoreSQL\" >/dev/null 2>&1 &");

Thomas