Spatie Laravel Backup - sh: mysqldump: command not found

The problem

One of the software projects I'm working on uses the fantastic Laravel-Backup packages from Spatie.

The application needs to run on-demand backups from the web interface. When I called Laravel's Artisan::call() method, I ran into this error:

sh: mysqldump: command not found

The solution

If you've confirmed that MySQL or MariaDB is installed and running, find the binary with:

which mysqldump

Then add the path to the binary with the following config change in your config/database.php file:

'mariadb' => [
  ...
  'dump' => [
    'dump_binary_path' => env("DUMP_BINARY_PATH"),
  ]
]

The DUMP_BINARY_PATH environment variable points to your mysqldump path. In my case, it was:

/opt/homebrew/opt/mariadb@10.11/bin

Just include the path to the binary, not the binary itself.

Success! You should now be able to run the command from your web interface.