Command not found: mysqldump error on running backup with empty databases list

[alies-dev]

version: latest (9.2.4)

Such an error happens on running backup:run when databases array in the config is empty:

// backup.php
return [
    'backup' => [
        'source' => [
            'databases' => [], // empty list
        ],
    ],
];

The dump process failed with a none successful exitcode.
Exitcode
========
127: Command not found

Output
======
<no output>

Error Output
============
sh: 1: mysqldump: not found

Context:

[
  {
    "exception": "[object] (Spatie\\Backup\\Exceptions\\BackupFailed(code: 0): The dump process failed with a none successful exitcode.
Exitcode
========
127: Command not found

Output
======
<no output>

Error Output
============
sh: 1: mysqldump: not found
 at %project%/vendor/spatie/laravel-backup/src/Exceptions/BackupFailed.php:17)
[stacktrace]
#0 %project%/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(187): Spatie\\Backup\\Exceptions\\BackupFailed::from()
#1 %project%/vendor/spatie/laravel-backup/src/Commands/BackupCommand.php(72): Spatie\\Backup\\Tasks\\Backup\\BackupJob->run()
#2 %project%/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Spatie\\Backup\\Commands\\BackupCommand->handle()
#3 %project%/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#4 %project%/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#5 %project%/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#6 %project%/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#7 %project%/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#8 %project%/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#9 %project%/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#10 %project%/vendor/spatie/laravel-backup/src/Commands/BaseCommand.php(29): Illuminate\\Console\\Command->run()
#11 %project%/vendor/symfony/console/Application.php(1094): Spatie\\Backup\\Commands\\BaseCommand->run()
#12 %project%/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()
#13 %project%/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()
#14 %project%/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#15 %project%/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1208): Illuminate\\Foundation\\Console\\Kernel->handle()
#16 %project%/artisan(13): Illuminate\\Foundation\\Application->handleCommand()
#17 {main}

[previous exception] [object] (Spatie\\DbDumper\\Exceptions\\DumpFailed(code: 0): The dump process failed with a none successful exitcode.
Exitcode
========
127: Command not found

Output
======
<no output>

Error Output
============
sh: 1: mysqldump: not found
 at %project%/vendor/spatie/db-dumper/src/Exceptions/DumpFailed.php:14)
[stacktrace]
#0 %project%/vendor/spatie/db-dumper/src/DbDumper.php(194): Spatie\\DbDumper\\Exceptions\\DumpFailed::processDidNotEndSuccessfully()
#1 %project%/vendor/spatie/db-dumper/src/Databases/MySql.php(170): Spatie\\DbDumper\\DbDumper->checkIfDumpWasSuccessFul()
#2 %project%/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(296): Spatie\\DbDumper\\Databases\\MySql->dumpToFile()
#3 [internal function]: Spatie\\Backup\\Tasks\\Backup\\BackupJob->{closure:Spatie\\Backup\\Tasks\\Backup\\BackupJob::dumpDatabases():260}()
#4 %project%/vendor/laravel/framework/src/Illuminate/Collections/Arr.php(609): array_map()
#5 %project%/vendor/laravel/framework/src/Illuminate/Collections/Collection.php(799): Illuminate\\Support\\Arr::map()
#6 %project%/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(260): Illuminate\\Support\\Collection->map()
#7 %project%/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(199): Spatie\\Backup\\Tasks\\Backup\\BackupJob->dumpDatabases()
#8 %project%/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(173): Spatie\\Backup\\Tasks\\Backup\\BackupJob->createBackupManifest()
#9 %project%/vendor/spatie/laravel-backup/src/Commands/BackupCommand.php(72): Spatie\\Backup\\Tasks\\Backup\\BackupJob->run()
#10 %project%/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Spatie\\Backup\\Commands\\BackupCommand->handle()
#11 %project%/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#12 %project%/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#13 %project%/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#14 %project%/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#15 %project%/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#16 %project%/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#17 %project%/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#18 %project%/vendor/spatie/laravel-backup/src/Commands/BaseCommand.php(29): Illuminate\\Console\\Command->run()
#19 %project%/vendor/symfony/console/Application.php(1094): Spatie\\Backup\\Commands\\BaseCommand->run()
#20 %project%/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()
#21 %project%/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()
#22 %project%/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#23 %project%/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1208): Illuminate\\Foundation\\Console\\Kernel->handle()
#24 %project%/artisan(13): Illuminate\\Foundation\\Application->handleCommand()
#25 {main}

[alies-dev]

I created a PR #1878 with a failing test

[a1bdelrahmanrezk]

in config/database.php :
in mysql driver :
add this lines:
'dump' => [
'dump_binary_path' => 'E:\laragon\bin\mysql\mysql-8.0.30-winx64\bin', //path of mysqldump.exe without it
'use_single_transaction',
'timeout' =>60 * 5,
],

full code of mysql driver :
'mysql' => [
'driver' => 'mysql',
'url' => env('DB_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'laravel'),
'username' => env('DB_USERNAME', 'root'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => env('DB_CHARSET', 'utf8mb4'),
'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
'options' => extension_loaded('pdo_mysql') ? array_filter([
PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
]) : [],
'dump' => [
'dump_binary_path' => 'E:\laragon\bin\mysql\mysql-8.0.30-winx64\bin', //path of mysqldump.exe without it
'use_single_transaction',
'timeout' =>60 * 5,
],
],