database - 一般错误 : 'mysqldump' is not recognized as an internal or external command

Question

我正在尝试使用 Spatie 包 从我的 Laravel 应用程序进行备份，但是在运行 backup:run commend 时，我得到了这个错误:

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.

如何在本地主机和生产环境中解决这个问题？

Answer 1

在您的 config/database.php 文件中，编辑 mysql 数据库配置并添加:

'dump' => [
               'dump_binary_path' => 'C:/xampp/mysql/bin/', // only the path, so without `mysqldump` or `pg_dump`
               'use_single_transaction',
               'timeout' => 60 * 5, // 5 minute timeout
            ],