I have a couple of docker containers for my Laravel 9 app (Nginx, PHP, MySQL, PHPMyAdmin, etc). I use spatie package to backup my database.
I don’t know how to set the path to the mysqldump file as it’s in the docker container! I tried many different paths mentioned on the internet (e.g. ‘var/lib/mysql’, ‘mysql/bin’, ‘usr/bin’, etc), but none of them works!
Fortunately, when I run the following command on the server, the backup file is generated successfully, so I think the mysqldump file is in the ‘usrlib’:
docker exec MY-CONTAINER-NAME /usr/bin/mysqldump -u root –password=MY-PASSWORD DATABASE-NAME > storage/app/backups/backup-test.sql
The following is my MySQL service definition that I have in my docker-compose.yml file:
mysql:
image: mysql:8.0
container_name: mysql
restart: unless-stopped
tty: true
volumes:
- ./mysql:/var/lib/mysql
environment:
MYSQL_ROOT_PASSWORD: {{root-passowrd}}
SERVICE_NAME: mysql
networks:
- laravel
Here is the MySQL settings in config/database.php:
'mysql' => [ 'driver' => 'mysql', 'url' => env('DATABASE_URL'), 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'prefix_indexes' => true, 'strict' => true, 'engine' => null, 'dump' => [ 'dump_binary_path' => '/usr/bin', 'use_single_transaction', 'timeout' => 60 * 5, ], 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), ]) : [], ],
That would be great, if someone can help me to resolve this issue!
Here is the error I get when I run
docker compose exec php php artisan backup:run
Backup failed because The dump process failed with a none successful
exitcode. Exitcode
======== 127: Command not foundOutput
======Error Output
============ sh: 1: /usr/bin/mysqldump: not found .
#0 /var/www/vendor/spatie/db-dumper/src/DbDumper.php(178): SpatieDbDumperExceptionsDumpFailed::processDidNotEndSuccessfully(Object(SymfonyComponentProcessProcess))
#1 /var/www/vendor/spatie/db-dumper/src/Databases/MySql.php(143): SpatieDbDumperDbDumper->checkIfDumpWasSuccessFul(Object(SymfonyComponentProcessProcess),
‘/var/www/storag…’)
#2 /var/www/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(274):
SpatieDbDumperDatabasesMySql->dumpToFile(‘/var/www/storag…’)
#3 [internal function]: SpatieBackupTasksBackupBackupJob->SpatieBackupTasksBackup{closure}(Object(SpatieDbDumperDatabasesMySql),
‘mysql’)
#4 /var/www/vendor/laravel/framework/src/Illuminate/Collections/Arr.php(560):
array_map(Object(Closure), Array, Array)
#5 /var/www/vendor/laravel/framework/src/Illuminate/Collections/Collection.php(739):
IlluminateSupportArr::map(Array, Object(Closure))
#6 /var/www/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(277):
IlluminateSupportCollection->map(Object(Closure))
#7 /var/www/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(188):
SpatieBackupTasksBackupBackupJob->dumpDatabases()
#8 /var/www/vendor/spatie/laravel-backup/src/Tasks/Backup/BackupJob.php(160):
SpatieBackupTasksBackupBackupJob->createBackupManifest()
#9 /var/www/vendor/spatie/laravel-backup/src/Commands/BackupCommand.php(58):
SpatieBackupTasksBackupBackupJob->run()
#10 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36):
SpatieBackupCommandsBackupCommand->handle()
#11 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41):
IlluminateContainerBoundMethod::IlluminateContainer{closure}()
#12 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93):
IlluminateContainerUtil::unwrapIfClosure(Object(Closure))
#13 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37):
IlluminateContainerBoundMethod::callBoundMethod(Object(IlluminateFoundationApplication),
Array, Object(Closure))
#14 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(651):
IlluminateContainerBoundMethod::call(Object(IlluminateFoundationApplication),
Array, Array, NULL)
#15 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182):
IlluminateContainerContainer->call(Array)
#16 /var/www/vendor/symfony/console/Command/Command.php(312): IlluminateConsoleCommand->execute(Object(SymfonyComponentConsoleInputArgvInput),
Object(IlluminateConsoleOutputStyle))
#17 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(152):
SymfonyComponentConsoleCommandCommand->run(Object(SymfonyComponentConsoleInputArgvInput),
Object(IlluminateConsoleOutputStyle))
#18 /var/www/vendor/spatie/laravel-backup/src/Commands/BaseCommand.php(28):
IlluminateConsoleCommand->run(Object(SymfonyComponentConsoleInputArgvInput),
Object(SymfonyComponentConsoleOutputConsoleOutput))
#19 /var/www/vendor/symfony/console/Application.php(1020): SpatieBackupCommandsBaseCommand->run(Object(SymfonyComponentConsoleInputArgvInput),
Object(SymfonyComponentConsoleOutputConsoleOutput))
#20 /var/www/vendor/symfony/console/Application.php(312): SymfonyComponentConsoleApplication->doRunCommand(Object(SpatieBackupCommandsBackupCommand),
Object(SymfonyComponentConsoleInputArgvInput),
Object(SymfonyComponentConsoleOutputConsoleOutput))
#21 /var/www/vendor/symfony/console/Application.php(168): SymfonyComponentConsoleApplication->doRun(Object(SymfonyComponentConsoleInputArgvInput),
Object(SymfonyComponentConsoleOutputConsoleOutput))
#22 /var/www/vendor/laravel/framework/src/Illuminate/Console/Application.php(102):
SymfonyComponentConsoleApplication->run(Object(SymfonyComponentConsoleInputArgvInput),
Object(SymfonyComponentConsoleOutputConsoleOutput))
#23 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155):
IlluminateConsoleApplication->run(Object(SymfonyComponentConsoleInputArgvInput),
Object(SymfonyComponentConsoleOutputConsoleOutput))
#24 /var/www/artisan(37): IlluminateFoundationConsoleKernel->handle(Object(SymfonyComponentConsoleInputArgvInput),
Object(SymfonyComponentConsoleOutputConsoleOutput))
#25 {main} Sending notification failed Backup failed because: The dump process failed with a none successful exitcode. Exitcode
======== 127: Command not foundOutput
======
2
Answers
I managed to resolve the issue differently! I installed MySQL client in my PHP container via Dockerfile as follows:
Dockerfile :
Then, I used the following command (in my controller) to generate the backup. You can trigger this via a cron job to generate backup periodically:
In my case, I put a button in the UI for admins to generate and download backups whenever needed. So when the button is clicked, an ajax call is triggered to run the command in the shell of my PHP container. The command I used in my controller is as follows:
My Controller:
At the end, I put my docker-compose.yml file in case it can help someone!
you can use
dump_binary_path
like this]