How to execute mysqldump locally using DBngin and Craft CMS

.env

#DB Backup Restore *LOCAL ONLY*
#You can access other DB variables to add to the command. EX: {server}, {user}, {port}…
LOCAL_DB_BIN="/Users/Shared/DBngin/mysql/8.0.27/bin/"
BACKUP_COMMAND="${LOCAL_DB_BIN}mysqldump -h {server} -u {user} --port {port}  --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --set-charset --triggers --single-transaction --no-data --result-file=\"{file}\" {database} && ${LOCAL_DB_BIN}mysqldump -h {server} -u {user} --port {port}  --add-drop-table --comments --create-options --dump-date --no-autocommit --routines --set-charset --triggers --no-create-info --ignore-table={database}.assetindexdata --ignore-table={database}.assettransformindex --ignore-table={database}.cache --ignore-table={database}.sessions --ignore-table={database}.templatecaches --ignore-table={database}.templatecachecriteria --ignore-table={database}.templatecacheelements --ignore-table={database}.templatecachequeries {database} >> \"{file}\""
RESET_COMMAND="${LOCAL_DB_BIN}mysql -h {server} -u {user} --port {port}  {database} < \"{file}\""

general.php

<?php
use craft\helpers\App;

return [
    // Global settings
    '*' => [
    ],

    // Dev environment settings
    'dev' => [
        'backupCommand' => getenv('BACKUP_COMMAND'),
        'restoreCommand'=> getenv('RESTORE_COMMAND')
    ],

    // Staging environment settings
    'staging' => [
    ],

    // Production environment settings
    'production' => [
    ],
];