运行php-artisan备份时出错:run

Question

大家好，我目前正在开发laravel 5.8，最近安装了spatie/laraavel备份包来备份我的文件和数据库，我完成了使用该包所需的所有步骤，但当我运行命令时php artisan backup:run它给出了许多错误，如下

正在启动备份。。。正在转储数据库u452010341_qkcg。。。备份失败因为转储进程失败，exitcode 1:常规错误："mysqldump"未被识别为内部或外部命令，可操作程序或批处理文件。

#0 C:xampphtdocsbvendorspatiedb-dumpersrcDbDumper.php(246): SpatieDbDumperExceptionsDumpFailed::processDidNotEndSuccessfully(Object(SymfonyComponentProcessProcess))
#1 C:xampphtdocsbvendorspatiedb-dumpersrcDatabasesMySql.php(190): SpatieDbDumperDbDumper->checkIfDumpWasSuccessFul(Object(SymfonyComponentProcessProcess), 'C:\xampp\htdocs...')
#2 C:xampphtdocsbvendorspatielaravel-backupsrcTasksBackupBackupJob.php(250): SpatieDbDumperDatabasesMySql->dumpToFile('C:\xampp\htdocs...')
#3 [internal function]: SpatieBackupTasksBackupBackupJob->SpatieBackupTasksBackup{closure}(Object(SpatieDbDumperDatabasesMySql), 'mysql')
#4 C:xampphtdocsbvendorlaravelframeworksrcIlluminateSupportCollection.php(1120): array_map(Object(Closure), Array, Array)
#5 C:xampphtdocsbvendorspatielaravel-backupsrcTasksBackupBackupJob.php(253): IlluminateSupportCollection->map(Object(Closure))
#6 C:xampphtdocsbvendorspatielaravel-backupsrcTasksBackupBackupJob.php(167): SpatieBackupTasksBackupBackupJob->dumpDatabases()
#7 C:xampphtdocsbvendorspatielaravel-backupsrcTasksBackupBackupJob.php(143): SpatieBackupTasksBackupBackupJob->createBackupManifest()
#8 C:xampphtdocsbvendorspatielaravel-backupsrcCommandsBackupCommand.php(52): SpatieBackupTasksBackupBackupJob->run()
#9 [internal function]: SpatieBackupCommandsBackupCommand->handle()
#10 C:xampphtdocsbvendorlaravelframeworksrcIlluminateContainerBoundMethod.php(32): call_user_func_array(Array, Array)
#11 C:xampphtdocsbvendorlaravelframeworksrcIlluminateContainerBoundMethod.php(90): IlluminateContainerBoundMethod::IlluminateContainer{closure}()
#12 C:xampphtdocsbvendorlaravelframeworksrcIlluminateContainerBoundMethod.php(34): IlluminateContainerBoundMethod::callBoundMethod(Object(IlluminateFoundationApplication), Array, Object(Closure))
#13 C:xampphtdocsbvendorlaravelframeworksrcIlluminateContainerContainer.php(576): IlluminateContainerBoundMethod::call(Object(IlluminateFoundationApplication), Array, Array, NULL)
#14 C:xampphtdocsbvendorlaravelframeworksrcIlluminateConsoleCommand.php(183): IlluminateContainerContainer->call(Array)
#15 C:xampphtdocsbvendorsymfonyconsoleCommandCommand.php(255): IlluminateConsoleCommand->execute(Object(SymfonyComponentConsoleInputArgvInput), Object(IlluminateConsoleOutputStyle))
#16 C:xampphtdocsbvendorlaravelframeworksrcIlluminateConsoleCommand.php(170): SymfonyComponentConsoleCommandCommand->run(Object(SymfonyComponentConsoleInputArgvInput), Object(IlluminateConsoleOutputStyle))
#17 C:xampphtdocsbvendorspatielaravel-backupsrcCommandsBaseCommand.php(16): IlluminateConsoleCommand->run(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#18 C:xampphtdocsbvendorsymfonyconsoleApplication.php(1012): SpatieBackupCommandsBaseCommand->run(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#19 C:xampphtdocsbvendorsymfonyconsoleApplication.php(272): SymfonyComponentConsoleApplication->doRunCommand(Object(SpatieBackupCommandsBackupCommand), Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#20 C:xampphtdocsbvendorsymfonyconsoleApplication.php(148): SymfonyComponentConsoleApplication->doRun(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#21 C:xampphtdocsbvendorlaravelframeworksrcIlluminateConsoleApplication.php(90): SymfonyComponentConsoleApplication->run(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#22 C:xampphtdocsbvendorlaravelframeworksrcIlluminateFoundationConsoleKernel.php(133): IlluminateConsoleApplication->run(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#23 C:xampphtdocsbartisan(37): IlluminateFoundationConsoleKernel->handle(Object(SymfonyComponentConsoleInputArgvInput), Object(SymfonyComponentConsoleOutputConsoleOutput))
#24 {main}
Backup failed because: The dump process failed with exitcode 1 : General error : '"mysqldump"' is not recognized as an internal or external command,
operable program or batch file.

我搜索了解决方案，找到了下面的代码：

'connections' => [ 
'mysql' => [
'driver' => 'mysql'
...,
'dump' => [
'dump_binary_path' => '/path/to/the/binary', // only the path, so without `mysqldump` or `pg_dump`
'use_single_transaction',
'timeout' => 60 * 5, // 5 minute timeout
'exclude_tables' =>['table1', 'table2'],`enter code here`
'add_extra_option' =>'--optionname=optionvalue', 
]  
],

但我还是犯了同样的错误。。。我试了100多次，还是一无所获。所以，任何经历过这个问题的人，或者任何知道如何解决这个问题的机构，请帮助我。

Answer 1

在您找到的代码中，其中表示：

'dump_binary_path' => '/path/to/the/binary',

更改为：

'dump_binary_path' => 'C:xamppmysqlbin',

下次，请注意错误，因为在他的案例中，问题描述得很好！

问候

Answer 2

现在您还需要对这一行进行注释：//'add_extra_option'=>'--optionname=optionvalue'，

为我工作。