Powershell Script To Back Up MySQL

backup.ps1

$DateString = (Get-Date -Format "yyyyMMdd")
$Databases = @("wp_database_1", "wp_database_2", "wp_database_3")

foreach ($databaseName in $Databases)
{
    $BackupCommand = '"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe" 
                     --defaults-file=credentials.ini --host=localhost 
                     --protocol=tcp --port=1234 --default-character-set=utf8 --add-drop-database 
                     --add-drop-table --result-file="Z:\Backups\Database\MySQL\' + 
                     $databaseName + '\bak_' + $DateString + '.sql" --skip-triggers "' + 
                     $databaseName + '"'

    Invoke-Expression "& $BackupCommand"
}

credentials.ini

[mysqldump]
user=<USERID>
password=<PASSWORD>