Problem with mysqldump

nicdp

I used this code until last week to make a dump of my database.

$create_backup = exec("/usr/bin/mysqldump --opt --host=sql.example.com --user=user --password=password dbname > /home/mhd-17/www.example.com/htdocs/temp/backup.sql");

But the exec() function has been disactivated on my server. I tried to put system() and passthru() instead of exec(), but the result is a backup file of 0 KB.

Do you know how I could solve this without using thing like phpMyAdmin?

tsinka

Hi,

create a phpinfo() script and check if safe_mode has been enabled.

Post the output of the script as attachment (save it with your browser and rename the file to .txt).

If safe_mode restrictions are active then you might need to use a workaround.

Thomas

nicdp

From PHPINFO:
- safe_mode: Off
- safe_mode_exec_dir: /usr/local/web/php/sbin

nicdp

I attach output.

nicdp

Attachment

nicdp

I can't get the backup.txt file uploaded, however it contains nothing.

tsinka

What setting does open_basedir have (empty or set) ?

EDIT: execute the following command using passthru and post the output

/usr/bin/mysqldump 2>&1

Thomas

nicdp

open_basedir: no value

Output of

$test = passthru("/usr/bin/mysqldump 2>&1");
echo $test;

is blank.

tsinka

Interesting. safe_mode is off but safe_mode_exec_dir is set ....

is safe_mode set to off locally and globally (check the output) ?

You wrote that you couldn't post the text file. Which browser do you use ? I don't understand why your browser didn't save the HTML page correctly ... can I access the phpinfo script directly ? The link you posted earlier didn't work.

Thomas

nicdp

http://www.camerazimmaro.it/info.php

nicdp

I was using firefox, better IE?

tsinka

Hmmm .... I see

disable_functions: dl,passthru,popen

So passthru is disabled and not exec. What do you get with

$lastline = system("/usr/bin/mysqldump 2>&1");
echo $lastline;

if (is_file("/usr/bin/mysqldump"))
  echo "exists";
else
  echo "doesn't exist";

Thomas

nicdp

With the first I get:

sh: /usr/bin/mysqldump: No such file or directory sh: /usr/bin/mysqldump: No such file or directory

Does that mean that the directory of mysqldump has been changed?

I get no answer from the second.

tsinka

Either the file is somewhere else or PHP (the web server process) doesn't have execute read/execute permissions on that file.

You might be able to find the file with

system("/bin/which mysqldump 2>&1");
or
system("/usr/bin/which mysqldump 2>&1");

(try to use whereis instead of which if that doesn't return anything.

Thomas