Where is MYSQL and MYSQL Dump Paths ?

[Moogle Stiltzkin]

Hi,

I am trying to use this wordpress WP-DBManager plugin to perform some database backups. Unfortunately i have run across a hurdle as i am unsure about setting up the MYSQL Dump and MYSQL paths .... any ideas ?

Checking Backup Status
Checking Backup Folder (/share/MD0_DATA/Qweb/wp-content/backup-db) ...
Backup folder exists
Backup folder is writable

Checking MYSQL Dump Path ...
MYSQL dump path does NOT exist. Please check your mysqldump path under DB Options. If uncertain, contact your server administrator.

Checking MYSQL Path ...
MYSQL path does NOT exist. Please check your mysql path under DB Options. If uncertain, contact your server administrator.

Checking PHP Functions (passthru(), system() and exec()) ...
passthru() enabled.
system() enabled.
exec() enabled.

Please Rectify The Error Highlighted In Red Before Proceeding On.

http://wordpress.org/extend/plugins/wp-dbmanager/

[fribse]

Hi,

I am trying to use this wordpress WP-DBManager plugin to perform some database backups. Unfortunately i have run across a hurdle as i am unsure about setting up the MYSQL Dump and MYSQL paths .... any ideas ?

Checking Backup Status
Checking Backup Folder (/share/MD0_DATA/Qweb/wp-content/backup-db) ...
Backup folder exists
Backup folder is writable

Checking MYSQL Dump Path ...
MYSQL dump path does NOT exist. Please check your mysqldump path under DB Options. If uncertain, contact your server administrator.

Checking MYSQL Path ...
MYSQL path does NOT exist. Please check your mysql path under DB Options. If uncertain, contact your server administrator.

Checking PHP Functions (passthru(), system() and exec()) ...
passthru() enabled.
system() enabled.
exec() enabled.

Please Rectify The Error Highlighted In Red Before Proceeding On.

http://wordpress.org/extend/plugins/wp-dbmanager/

You can find paths to programs by doing this with putty

Code: Select all

cd /
find -name mysqldump

This will return

Code: Select all

./mnt/ext/opt/mysql/bin/mysqldump

Make sure that the path is setup correctly.

[Moogle Stiltzkin]

Ok this was what came out

Code: Select all

[~] # cd /
[/] # find -name mysqldump
./mnt/ext/opt/mysql/bin/mysqldump
[/] #

Ok so i managed to get the correct path which was same as the above but without the "." in the front.

Code: Select all

/mnt/ext/opt/mysql/bin/mysqldump

the mod says it is all ok.

Code: Select all

Checking Backup Status

Checking Backup Folder (/share/MD0_DATA/Qweb/wp-content/backup-db) ...
Backup folder exists
Backup folder is writable

Checking MYSQL Dump Path (/mnt/ext/opt/mysql/bin/mysqldump) ...
MYSQL dump path exists.

Checking MYSQL Path (/mnt/ext/opt/mysql/bin/mysqldump) ...
MYSQL path exists.

Checking PHP Functions (passthru(), system() and exec()) ...
passthru() enabled.
system() enabled.
exec() enabled.

Excellent. You Are Good To Go.

Note: The checking of backup status is still undergoing testing, it may not be accurate.
Backup Database

Thanks for your help

[khaihong]

Still helpful after 9 years I just installed the same WP-DBmanager plugin for my WordPress site and had the same questions

[Kellerassel]

still helpful after 11 years...
Try to make my qnap working to backup mySQldatabase with mysqldump....

so i had the same questions...

Thanks for help...

[dolbyman]

silent admiration wasn't possible? .. needed to necropost ?

[OneCD]

* topic locked to prevent further necroposting *