Allow to define port for MySQL

[psmysqlbackup.git] / psmysqlbackup.ps1

diff --git a/psmysqlbackup.ps1 b/psmysqlbackup.ps1
index 7ca585a28afe40a4736aae1ba3fbe79360883103..4e2a692f1dd8738a493cfa3e88212561acc0bff0 100644 (file)
--- a/psmysqlbackup.ps1
+++ b/psmysqlbackup.ps1
@@ -1,4 +1,5 @@
 [String]$configMysqlHost = "localhost"
+[Int32]$configMysqlPort = 3306
 [String]$configMysqlUser = "backup"
 [String]$configMysqlPassword = "backup"
 
@@ -6,17 +7,37 @@
 [String]$configMysqldumpCli = "C:\Program Files\MariaDB 10.5\bin\mysqldump.exe"
 
 [String]$configBackupDir = "backup"
-[String]$configRotate = 7
+[Int32]$configRotate = 7
 
 function Get-Databases() {
-    $databaseString = (& $configMysqlCli --host=$configMysqlHost --user=$configMysqlUser --password=$configMysqlPassword --batch --skip-column-names -e "SHOW DATABASES;")
+    $databaseString = (& $configMysqlCli --host=$configMysqlHost --port=$configMysqlPort --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) {
-    & $configMysqldumpCli --host=$configMysqlHost --user=$configMysqlUser --password=$configMysqlPassword --single-transaction --result-file=$target $database
+    & $configMysqldumpCli --host=$configMysqlHost --port=$configMysqlPort --user=$configMysqlUser --password=$configMysqlPassword --single-transaction --result-file=$target $database
+}
+
+function Rotate-Backups($backupDir) {
+    if($configRotate -le 0) {
+               return
+       }
+       
+       $keepBackupsCount = $configRotate
+       
+       Get-ChildItem $backupDir -File | Where-Object {($_.Name -match "^backup-.+-\d{8,}-\d{6}\.sql$")} | Sort-Object -Descending |
+       Foreach-Object {
+               if($keepBackupsCount -ge 0) {
+                       $keepBackupsCount--
+               }
+               
+               if($keepBackupsCount -eq -1) {
+                       Write-Output "Deleting backup $($_.FullName)"
+                       Remove-Item -Force $_.FullName
+               }
+       }
 }
 
 $currDaytime = Get-Date -format "yyyyMMdd-HHmmss"
@@ -33,4 +54,5 @@ foreach($d in $databases) {
     $databaseBackupFile = Join-Path -Path $databaseBackupDir -ChildPath "backup-$d-$currDaytime.sql"
     Write-Output "Backing up $d to $databaseBackupFile..."
     Create-Backup $d $databaseBackupFile
+    Rotate-Backups $databaseBackupDir
 }
\ No newline at end of file