From: Patrick Canterino Date: Mon, 27 Dec 2021 11:59:46 +0000 (+0100) Subject: Changed config variables to CamelCase X-Git-Tag: 0.1~21 X-Git-Url: https://git.p6c8.net/psmysqlbackup.git/commitdiff_plain/22cc4213448f24a39515d9b3c6a906b85dfbdb19 Changed config variables to CamelCase --- 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