PHPackages                             samhernandez/craft-db-paths - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. samhernandez/craft-db-paths

ActiveCraft-module[Database & ORM](/categories/database)

samhernandez/craft-db-paths
===========================

Fix failed Craft backups and restores with full paths to psql, mysql, and mysqldump executables.

1.0.2(6y ago)2965[1 issues](https://github.com/samhernandez/craft-db-paths/issues)MITPHPCI failing

Since Dec 3Pushed 6y ago1 watchersCompare

[ Source](https://github.com/samhernandez/craft-db-paths)[ Packagist](https://packagist.org/packages/samhernandez/craft-db-paths)[ RSS](/packages/samhernandez-craft-db-paths/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (3)Dependencies (1)Versions (3)Used By (0)

Craft DB Paths Module
=====================

[](#craft-db-paths-module)

Skip to [the usage instructions](##usage) if you already know the story.

Background
----------

[](#background)

Craft relies by default on the `mysqldump` and `mysql` executables to backup and restore databases. The default backup command looks like this:

```
mysqldump […options…] {database} > {file}'

```

The problem is that, while `mysqldump` might be available in the system, PHP running under a web request doesn’t know where to find it because it’s not in any directories specified in the `PATH` environmental variable. This is true when running locally with MAMP. It’s also true sometimes on EC2 instances when running MariaDB on RDS.

For this reason, Craft provides two configuration variables for you: [`backupCommand`](https://docs.craftcms.com/v3/config/config-settings.html#backupcommand) and [`restoreCommand`](https://docs.craftcms.com/v3/config/config-settings.html#restorecommand). You can write your own command with the full path to the `mysqldump` executable. For MAMP it might be something like this:

```
/Applications/MAMP/Library/bin/mysqldump […options…] {database} > {file}

```

The thing is, Craft’s default dump command is really nice. It excludes unnecessary session, cache, and asset data. You can see how it’s built for MySQL in the [Schema::defaultBackupCommand()](https://github.com/craftcms/cms/blob/master/src/db/mysql/Schema.php#L146-L190) method. What if you could just replace `mysqldump` with its full path and not have to roll your own command? That's what this module is for.

Usage
-----

[](#usage)

### Installation

[](#installation)

This is a module for Craft CMS, not a plugin available in Craft's Plugin Store. It is installed with composer on the command line.

Run the following command in the root of your project.

```
composer require samhernandez/craft-db-paths
```

Open `/config/app.php`, add the `CraftDbPaths` class as a module, and bootstrap it. Example:

```
return [
    'modules' => [
        'craft-db-paths' => \samhernandez\craftdbpaths\CraftDbPaths::class,
    ],
    'bootstrap' => ['craft-db-paths'],
];
```

### Configuration

[](#configuration)

Add any of the following env vars to your `.env` file. Here is an example for MAMP on a Mac with MySQL.

```
PATH_TO_MYSQL=/Applications/MAMP/Library/bin/mysql
PATH_TO_MYSQLDUMP=/Applications/MAMP/Library/bin/mysqldump

```

If necessary, you can add paths for Postgres too.

```
PATH_TO_PSQL=/usr/local/bin/psql
PATH_TO_PGDUMP=/usr/local/bin/pg_dump

```

No configuration file is necesary, just env variables set in your `.env` or otherwise.

###  Health Score

28

—

LowBetter than 54% of packages

Maintenance10

Infrequent updates — may be unmaintained

Popularity19

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity62

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~403 days

Total

2

Last Release

2310d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/ab29a69c82ad944f64757e381a26ca9d30fc12c77796040706e8272a1f39be8a?d=identicon)[samhernandez](/maintainers/samhernandez)

---

Top Contributors

[![samhernandez](https://avatars.githubusercontent.com/u/123042?v=4)](https://github.com/samhernandez "samhernandez (3 commits)")

---

Tags

backupmysqlmysqldumpCraftpsql

### Embed Badge

![Health badge](/badges/samhernandez-craft-db-paths/health.svg)

```
[![Health](https://phpackages.com/badges/samhernandez-craft-db-paths/health.svg)](https://phpackages.com/packages/samhernandez-craft-db-paths)
```

###  Alternatives

[ifsnop/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

1.3k5.5M68](/packages/ifsnop-mysqldump-php)[phpbu/phpbu

PHP Backup utility.

1.3k89.0k4](/packages/phpbu-phpbu)[rah/danpu

Zero-dependency MySQL dump library for easily exporting and importing databases

64401.8k10](/packages/rah-danpu)[clouddueling/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

1.3k22.9k](/packages/clouddueling-mysqldump-php)[cytopia/mysqldump-secure

Secure mysqldump script with encryption, compression, logging, blacklisting and Nagios monitoring integration

1474.7k1](/packages/cytopia-mysqldump-secure)[druidfi/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

35489.8k6](/packages/druidfi-mysqldump-php)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)