$PATH variable location for backups

Question

Folks:

This is surely something real basic. I have not been able to create a database backup manually or when updating.

• Mysqldump is installed.
• I know the location of mysqldump (/usr/local/bin/mysqldump).
• The log doesn't appear to reveal anything.

I have modified the .env file using the info from the MAMP database backup article (substituting the path for the MAMP one in the article). No joy.

According to the config docs, I need to change the PATH variable.

The question is: how do I do this? Specifically:

• Where is this change made? Which file? general.php? .env? Elsewhere?
• What is the syntax to make this work?

Answer 1

The article was not quite right as it was for MAMP. What I did was add putenv("PATH={$_SERVER["PATH"]}:/usr/local/bin"), in the general.php file which resolved the issue. I didn't change the standard BACKUP_COMMAND in the .env file.

Answer 2

It's not just editing the .env file; you also need to modify the config to make use of those options; which is part two of that article you linked to.

You could also try adding a PATH variable to your .env which includes "/usr/local/bin" in it.

Update: The .env won't override an existing environment var by default. In most linux server setups this isn't a problem because the "www-data" or "apache" user doesn't have that set by default.

For MAMP, local dev or vagrant development; that path is likely set. If you want your .env settings to overwrite existing settings; change the web/index.php file to use Dotenv\Dotenv::create(CRAFT_BASE_PATH)->overload(); instead of Dotenv\Dotenv::create(CRAFT_BASE_PATH)->load();