mysqldump command lacks --host option

[mattsches]

Hello, I'm trying to create a database dump of a remote MySQL server (using spatie/laravel-backup).

However, \Spatie\DbDumper\Databases\MySql::getDumpCommand does not set the --host option for mysqldump, so the command tries to connect to a local DB host and subsequently fails.

I am aware that the host can be set like this when using the fluent syntax:

Spatie\DbDumper\Databases\MySql::create()
    ->setDbName($databaseName)
    ->setUserName($userName)
    ->setPassword($password)
    ->setHost($host)
    ->dumpToFile('dump.sql');

But that doesn't help in my case, I guess. Any ideas?

Edit: A workaround could be to add extra options to the database config for laravel-backup:

…
'dump' => [
    'add_extra_option' => '--host='.env('DB_HOST') . ' --user='.env('DB_USERNAME') . ' --password='.env('DB_PASSWORD'),
],
…