mySQL And mySQLdump Path

[MyNet-Tony]

I am running WordPress and I want to use a plugin that backups the database automatically. The only problem is that I don't know what the mysql and mysqldump path is. Every path I have tried can't be found by the plugin. Any one with any insight would be helpful.

[thisisit3]

Usually they are placed under /usr/bin/

[Smithjp]

mysql and mysqldump binary should be in /usr/bin but it may be at different path on your VPS. You can check the path as:

whereis mysql

whereis mysqldump

[MyNet-Tony]

Tried that, none of the options it gave me worked. Could it be a permissions issue?

[Connie]

What back up plug in are you using? I have a backup plug in on both my blogs, and I don't recall ever having to provide a path other than the default path in the set up.

[MyNet-Tony]

WP-DBMANAGER by Lester Chan
http://lesterchan.net/wordpress/

[Vin DSL]

Interesting...

I went to install that plug-in and, 'Bad Behavior' blocked me from my own web site!

http://www.bad-behavior.ioerror.us/2...behavior-2011/

Luckily, upgrading 'Bad Behavior' to the latest version did the trick...

On with the show!

[MyNet-Tony]

Yeah, let me know how DBManager goes for you.

[Vin DSL]

Okay, I dropped in the WP-DBMANAGER plugin, activated it, and BOOM!

Didn't have to config jack!

WP-DBMANAGER is showing these paths in the DB Options tab (SDX):

Path To mysqldump:  /usr/bin/mysqldump

Path To mysql:  /usr/bin/mysql

Path To Backup:  /home/example/public_html/example/wp-content/backup-db

Looks like a V nice plug-in!

Thanks!!!

[MyNet-Tony]

Yeah, I tried those paths for mysqldump and mysql and I get an error under the BackupDB tab :

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

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

I wonder if its a permissions thing or something with SSH because I think it uses that to access the mysql and mysqldump.

[Vin DSL]

Here's what I'm seeing...

Checking Backup Status

Checking Backup Folder (/home/example/public_html/example/wp-content/backup-db) ...
Backup folder exists
Backup folder is writable

Checking MYSQL Dump Path (/usr/bin/mysqldump) ...
MYSQL dump path exists.

Checking MYSQL Path (/usr/bin/mysql) ...
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.

[Vin DSL]

Performed a backup. Here's the header response...

Database Backed Up Successfully On 'December 12, 2007 @ 11:38 am'.

[Vin DSL]

I wonder if its a permissions thing or something with SSH because I think it uses that to access the mysql and mysqldump.

I just checked...

Everything was created and backed-up just fine!

The permissions on the folders are octal 0755... 0644 on the dump file.

Gotta run! BBL!

[jason]

Tony,

What kind of server are you on (shared, vps, etc.). If you're on dedicated or VPS, what kind of control panel (if any) are you using? That might help decipher these issues.

--Jason

[MyNet-Tony]

I am running a VPS with CentOS, Apache and Plesk CP