WordPress.org

Forums

WP-DBManager
mysqldump error (2 posts)

  1. Andre Pietsch
    Member
    Posted 4 years ago #

    Hey...

    I have 2 virtual domains on the same linux server

    http://www.dom1.de
    http://www.dom2.de

    On both are wordpress instances with dbmanager installed. Both options of dbmanager are exctly the same instead of the target path for the backup. those target paths are in the belonging subfolders of the domains.

    The rights of both db-backup folders are set to 0777 and the same .htacces file is in place. Both folders belong to the user and group the apache server is running on.

    The problem is that the backup on dom1 works without any problem but on dom2 I get the following error in the /var/log/messages

    sh: /mysqldump: No such file or directory

    The mysqldump option of both instances is set to /usr/bin/mysqldump. I had a look into the wp_options table of both instances to be sure.

    The command that is send to passthru() of dom1 is:

    /usr/bin/mysqldump --host="localhost" --user="dom1" --password="dom1pass" --add-drop-table --skip-lock-tables wp_dom1 > /srv/www/vhosts/dom1.de/httpdocs/wp-content/backup-db/1307800583_-_wp_dom1.sql

    and of dom2 is:

    /usr/bin/mysqldump --host="localhost" --user="dom2" --password="dom2pass" --add-drop-table --skip-lock-tables wp_dom2 > /srv/www/vhosts/dom2.de/httpdocs/wp-content/backup-db/1307800646_-_wp_dom2.sql

    Has anyone an idea what the problem could be? Could it be a problem with the php settings?

    regards

  2. Andre Pietsch
    Member
    Posted 4 years ago #

    I returned the $error of passthru() and it returned 0 on dom1, were everything is fine, and 127 on dom2.

    A short googeling for that showed that it could be a problem with the safe_mode. So I checked the safe_mode option on both instances and saw that the safe_mode for dom1 was off and for dom2 was on. Disabling the safe mode on dom2 fixed the problem.

    Is it possible to implement a check for the safe_mode option and give a hint to the admin that the safe_mode has to be off for the backups to work properly?

    I know that the safe_mode is deprecated in some newer php versions so that should be checked too.

    kind reagards

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic