I have a MySQL command line I am trying to run from a PHP script, but cannot get it to work. (The MySQL command backs up my database, using “mysqldump”)
The MySQL command line works fine from SSH, and generates the file just fine.
My PHP script also seems to be set up okm, using “shell_exec” to run shell commands. When I give it a command line using “ls” it returns results just fine.
But when I replace this ls sample command with my mysqldump command line, I get no results and no file gets created.
So to recap: a command line works fine from SSH, but will not work via shell_exec.
A colleague told me I need to establish the permissions of the PHP script, but not sure about this…
any help is appreciated!