From 22cc4213448f24a39515d9b3c6a906b85dfbdb19 Mon Sep 17 00:00:00 2001 From: Patrick Canterino Date: Mon, 27 Dec 2021 12:59:46 +0100 Subject: [PATCH 1/1] Changed config variables to CamelCase --- psmysqlbackup.ps1 | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/psmysqlbackup.ps1 b/psmysqlbackup.ps1 index dca87c2..164bdeb 100644 --- a/psmysqlbackup.ps1 +++ b/psmysqlbackup.ps1 @@ -1,28 +1,28 @@ -[String]$config_mysql_host = "localhost" -[String]$config_mysql_user = "backup" -[String]$config_mysql_password = "backup" +[String]$configMysqlHost = "localhost" +[String]$configMysqlUser = "backup" +[String]$configMysqlPassword = "backup" -[String]$config_mysql_cli = "C:\Program Files\MariaDB 10.5\bin\mysql.exe" -[String]$config_mysqldump_cli = "C:\Program Files\MariaDB 10.5\bin\mysqldump.exe" +[String]$configMysqlCli = "C:\Program Files\MariaDB 10.5\bin\mysql.exe" +[String]$configMysqldumpCli = "C:\Program Files\MariaDB 10.5\bin\mysqldump.exe" -[String]$config_backup_dir = "backup" -[String]$config_rotate = 7 +[String]$configBackupDir = "backup" +[String]$configRotate = 7 function Get-Databases() { - $databaseString = (& $config_mysql_cli --host=$config_mysql_host --user=$config_mysql_user --password=$config_mysql_password --batch --skip-column-names -e "SHOW DATABASES;") + $databaseString = (& $configMysqlCli --host=$configMysqlHost --user=$configMysqlUser --password=$configMysqlPassword --batch --skip-column-names -e "SHOW DATABASES;") $databases = $databaseString.split([Environment]::NewLine) return $databases } function Create-Backup([String]$database, [String]$target) { - & $config_mysqldump_cli --host=$config_mysql_host --user=$config_mysql_user --password=$config_mysql_password --single-transaction --result-file=$target $database + & $configMysqldumpCli --host=$configMysqlHost --user=$configMysqlUser --password=$configMysqlPassword --single-transaction --result-file=$target $database } $databases = Get-Databases | Where-Object { $_ -ne "information_schema" -and $_ -ne "performance_schema"} foreach($d in $databases) { - $backupFile = $config_backup_dir + "\" + $d + ".sql" + $backupFile = $configBackupDir + "\" + $d + ".sql" Write-Output "Backing up $d to $backupFile..." Create-Backup $d $backupFile } \ No newline at end of file -- 2.34.1