[RESOLVED] how can I check the success of system() ?

steamPunk

I've got a bit of code I want to use to create db dumps from a CRON :

$commande = $cmd_mysql." --host=$db_server --user=$db_username --password=$db_password -C -Q -e --default-character-set=$db_charset --single-transaction  $db_name > $archive_SQL ";
$CR_exec = system($commande, $retval);
$mess .= "CR_exec = ".$retval."\n";

the sql file is saved to the server and I'm sent a message by mail. This all works fine but the line

$mess .= "CR_exec = ".$retval."\n";

outputs "CR_exec = 0" if the dump is successful and "CR_exec = 2" if I put in the wrong password so there seems to be more than just 1/0 returned

has anyone got a list of these return values and what they mean ? I had a look in the manual and it isn't in the page about system()

thanks

bradgrafelman

The value returned is set by the program, so the list of values is all integers in the interval [0, 255] (I think?). As to what they mean... well, any program can return any value it likes under any condition, so you'd have to consult the program's documentation.

steamPunk

bradgrafelman;10990624 wrote:
The value returned is set by the program, so the list of values is all integers in the interval [0, 255] (I think?). As to what they mean... well, any program can return any value it likes under any condition, so you'd have to consult the program's documentation.

damn! of course ! mysqldump isn't a php thing at all - it's mysql ....

so I had a look in the MySQL docs and found this :

    '00' indicates success.

'01' indicates a warning.

'02' indicates “not found.” These values are relevant only within the context of cursors and are used to control what happens when a cursor reaches the end of a data set.

Other values indicate an exception.

so I guess I can use that.

Thanks for the pointers there 🙂