Help: Backup mysql problem

[mach]

no. the host said it is /usr/bin/mysqldump

I had two different tech people tell me the same path

no where in the script that I can find does it reference this path. I tried changing the path in the script to that path, it didn't work either.

[mach]

what does chrotted while running php mean

unfortunately i don't have the logs from when it worked

[DrByte]

chroot is like a jailshell
these are linux/unix terms related to forcing security settings

if you are chroot'ed, that means your working area (in this case command-execution environment, akin to a DOS window) is restricted to only have access to the files/folders specified.

In your case, it appears that when PHP is granted exec() access, it's being chroot'ed to a path that doesn't have access/permission to the "required" binaries.

It would seem that your host has changed their PHP security restrictions since you last ran the program.

[mach]

thank you for the time and info.

I have a ticket into them with this info , I think I have a basic idea of what might be happening. they insist I should use the path

/usr/bib/mysqldump

I'll see what they say,

thanks

[DrByte]

lol ... they're right ... you "should" use that path.
It would seem that the command-line environment they're offering you doesn't allow that.

However, try this for kicks...

1. open the backup_mysql screen
2. click on Backup
3. edit the URL and add this to the end of it:

&debug=ON

...and press Enter
4. now click the backup button on the sidebox

Post the debug info from the top of the screen here.... without your passwords of course.

[mach]

Checking Path: /usr/bin/



COMMAND FILES SELECTED:
mysqlexe="/usr/bin/mysql"

mysqldumpexe="/usr/bin/mysqldump"


COMMAND: "/usr/bin/mysqldump" "--host=localhost" "--user=xuserx" "--password=xpwdx" --opt --complete-insert "--result-file=/home/xxx/public_html/adminxxxxx/backups/db_xdbx-20060904201447.sql" xdbx 2>&1
Result code: 127
valueA:
valueB:
ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED.

[DrByte]

Okay ... the tool is attempting to run the binary from the prescribed location, but the PHP security settings for chroot are preventing it from happening as required.

It's all up to your host now ...