WordPress.org

Ready to get started?Download WordPress

Forums

WP-DBManager
[resolved] mysql path not working, can't back up db (2 posts)

  1. hedera
    Member
    Posted 1 year ago #

    We've been using WP-DBManager for some years; http://lifering.org is a WordPress 3.4.2 site hosted on a virtual Linux server by GoDaddy. A week or so ago I rebuilt the site from a backup in order to upgrade the O/S from CentOS 5 to CentOS 6. As part of this we had to upgrade our control panel from Simple Control Panel to Plesk 11. It also changed all our base paths. Since the upgrade, WP-DBManager says that the path to MySQL (/usr/bin/mysql) is invalid, even though that IS the correct path.

    I read the earlier post on this and the link that suggests it isn't REALLY necessary to have that path. But when I try to run a manual backup it fails; and my latest automated backup was filesize 0.

    Any suggestions?

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

  2. hedera
    Member
    Posted 1 year ago #

    I solved this one with help from the good folks at StackOverflow.com. The rebuild changed some PHP settings, the one at issue was open_basedir:

    open_basedir = "/var/www/vhosts/lifering.org/:/tmp/"

    The solution was to create a hard link called mysql (could have been a symlink) in the /tmp directory and then change the MySQL path in WP-DBManager to /tmp/mysql. The error message immediately went away.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags