spatie / laravel-backup

A package to backup your Laravel app
https://spatie.be/docs/laravel-backup
MIT License
5.64k stars 763 forks source link

mysqldump: Got error: 1049: Unknown database 'production' when selecting the database #1832

Closed cbz1991 closed 2 months ago

cbz1991 commented 2 months ago

'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' => false, 'engine' => null, 'sslmode' => env('SSL_MODE'), 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), ]) : [], 'dump' => [ 'useSingleTransaction' => true, 'mysql_gtid_purged' => 'OFF' ], ],

spatie/laravel-backup: 8.8 Laravel: 10.48.19

I'm using a MySQL cluster from Digital Ocean. The database exists and is connected to the app.