Backup failed because The dump process failed with exitcode 127 : Command not found : sh: 1: /mysqldump: not found

[ankit20893]

i am using laradock
running backup when database is in a different docker container ie mariadb

Backup failed because The dump process failed with exitcode 127 : Command not found : sh: 1: /mysqldump: not found
.
#0 /var/www/devnagri-web/vendor/spatie/db-dumper/src/DbDumper.php(246): Spatie\DbDumper\Exceptions\DumpFailed::processDidNotEndSuccessfully(Object(Symfony\Component\Process\Process))
#1 /var/www/devnagri-web/vendor/spatie/db-dumper/src/Databases/MySql.php(144): Spatie\DbDumper\DbDumper->checkIfDumpWasSuccessFul(Object(Symfony\Component\Process\Process), '/var/www/devnag...')
#2 /var/www/devnagri-web/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(247): Spatie\DbDumper\Databases\MySql->dumpToFile('/var/www/devnag...')
#3 [internal function]: Spatie\Backup\Tasks\Backup\BackupJob->Spatie\Backup\Tasks\Backup{closure}(Object(Spatie\DbDumper\Databases\MySql), 'mysql')
#4 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Support/Collection.php(1064): array_map(Object(Closure), Array, Array)
#5 /var/www/devnagri-web/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(250): Illuminate\Support\Collection->map(Object(Closure))
#6 /var/www/devnagri-web/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(167): Spatie\Backup\Tasks\Backup\BackupJob->dumpDatabases()
#7 /var/www/devnagri-web/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(143): Spatie\Backup\Tasks\Backup\BackupJob->createBackupManifest()
#8 /var/www/devnagri-web/vendor/spatie/laravel-backup/src/Commands/BackupCommand.php(52): Spatie\Backup\Tasks\Backup\BackupJob->run()
#9 [internal function]: Spatie\Backup\Commands\BackupCommand->handle()
#10 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(32): call_user_func_array(Array, Array)
#11 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(90): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#12 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(34): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))
#13 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Container/Container.php(580): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)
#14 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container->call(Array)
#15 /var/www/devnagri-web/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#16 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Console/Command.php(170): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#17 /var/www/devnagri-web/vendor/spatie/laravel-backup/src/Commands/BaseCommand.php(16): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#18 /var/www/devnagri-web/vendor/symfony/console/Application.php(908): Spatie\Backup\Commands\BaseCommand->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#19 /var/www/devnagri-web/vendor/symfony/console/Application.php(269): Symfony\Component\Console\Application->doRunCommand(Object(Spatie\Backup\Commands\BackupCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#20 /var/www/devnagri-web/vendor/symfony/console/Application.php(145): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#21 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Console/Application.php(90): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#22 /var/www/devnagri-web/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(122): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#23 /var/www/devnagri-web/artisan(37): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#24 {main}
Backup failed because: The dump process failed with exitcode 127 : Command not found : sh: 1: /mysqldump: not found

[freekmurze]

This is caused by mysqldump not being found. Either move the mysqldump to location in mentioned in the error or add the current path the dump_binary_path in the database config (https://docs.spatie.be/laravel-backup/v6/installation-and-setup#dumping-the-database)

[rognales]

@ankit20893 did you get it to work?

[ankit20893]

Yes, thanks

…

On Wed, 11 Sep 2019 at 15:09, Zaiman Noris ***@***.***> wrote: @ankit20893 <https://github.com/ankit20893> did you get it to work? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#891?email_source=notifications&email_token=ADCDIHQEMD3PDFMSMPMSV7TQJC4FNA5CNFSM4HDHTHP2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD6N43TA#issuecomment-530304460>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADCDIHUCXHFMAEJXENRLC7TQJC4FNANCNFSM4HDHTHPQ> .

[mateo2181]

@ankit20893 what did yo do to mysqldump works fine? I have the same problem.

[act360]

Just in case anyone comes looking for this, find WORKSPACE_INSTALL_MYSQL_CLIENT and update it to true and rebuild workspace container.

WORKSPACE_INSTALL_MYSQL_CLIENT=true

[diadal]

@ankit20893 please can your explain how you get this fixed am facing same issue on command console it working fine but on $schedule->command('backup:run') not working same error

[henryejemuta]

Yes, thanks
…
On Wed, 11 Sep 2019 at 15:09, Zaiman Noris @.***> wrote: @ankit20893 https://github.com/ankit20893 did you get it to work? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#891?email_source=notifications&email_token=ADCDIHQEMD3PDFMSMPMSV7TQJC4FNA5CNFSM4HDHTHP2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD6N43TA#issuecomment-530304460>, or mute the thread https://github.com/notifications/unsubscribe-auth/ADCDIHUCXHFMAEJXENRLC7TQJC4FNANCNFSM4HDHTHPQ .

How did you get this to work as I'm having same issue using it with DO managed Database, seems to be an issue when the mysqldata is not in the same filesystem as the application being backup

[rognales]

I solved this by installing mysql client on laravel image

[henryejemuta]

I'm currently using DO App platform for the affected project, and it's currently not dockerized, I have included ext-mysql to composer.json but still stuck with same error

[henryejemuta]

If you're still having this issue, simply install MySQL Client, on Ubuntu you can do that with this code snippet sudo apt-get install -y default-mysql-client

[alkoumi]

The Solution for 2024 for those how using macOS

If you run into this issue and you have ruled out that you have mysql installed and running and you can find the binary with a:

run this command

which mysqldump

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

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

Where the DUMP_BINARY_PATH environment variable points to your mysqldump path. In my case, it was
/opt/homebrew/bin/mysqldump

don't forget .env

DUMP_BINARY_PATH=opt/homebrew/bin/mysqldump