Renamed $configRotate to $configBackupRotate

[psmysqlbackup.git] / psmysqlbackup.ps1

diff --git a/psmysqlbackup.ps1 b/psmysqlbackup.ps1
index bbfc0755de09620824ce54917429fb7faaf6fcb9..9f6b4e96978776edf63c6e3b9ba777b97b5e7db9 100644 (file)
--- a/psmysqlbackup.ps1
+++ b/psmysqlbackup.ps1
@@ -25,11 +25,12 @@ $configMysqldumpCli = "C:\Program Files\MariaDB 10.5\bin\mysqldump.exe"
 # Directory where to store the backups
 $configBackupDir = "backup"
 # Number of backups to keep, set to 0 to keep all backups
 # Directory where to store the backups
 $configBackupDir = "backup"
 # Number of backups to keep, set to 0 to keep all backups

-$configRotate = 7
+$configBackupRotate = 7

 
 # Directory where to store the logfiles
 $configLogDir = "log"
 # Number of logfiles to keep, set to 0 to keep all logfiles
 
 # Directory where to store the logfiles
 $configLogDir = "log"
 # Number of logfiles to keep, set to 0 to keep all logfiles

+# You should set this to at least the same as $configBackupRotate

 $configLogRotate = 7
 
 # Databases to backup, leave empty to backup all databases
 $configLogRotate = 7
 
 # Databases to backup, leave empty to backup all databases


@@ -212,6 +213,9 @@ function Invoke-FileRotation {
 
 $defaultDbExclude = @("information_schema", "performance_schema")
 
 
 $defaultDbExclude = @("information_schema", "performance_schema")
 

+$patternBackupFile = "^backup-.+-\d{8,}-\d{6}\.sql$"
+$patternLogFile = "^log-\d{8,}-\d{6}\.log$"
+

 $currDaytime = Get-Date -format "yyyyMMdd-HHmmss"
 
 $logFile = "$configLogDir\log-$currDaytime.log"
 $currDaytime = Get-Date -format "yyyyMMdd-HHmmss"
 
 $logFile = "$configLogDir\log-$currDaytime.log"


@@ -293,7 +297,7 @@ foreach($d in $databasesToBackup) {
     
     try {
         Create-Backup $d $databaseBackupFile
     
     try {
         Create-Backup $d $databaseBackupFile

-        Invoke-FileRotation -Dir $databaseBackupDir -MaxFiles $configRotate -Pattern "^backup-.+-\d{8,}-\d{6}\.sql$" -LogFile $logFile
+        Invoke-FileRotation -Dir $databaseBackupDir -MaxFiles $configBackupRotate -Pattern $patternBackupFile -LogFile $logFile

     }
     catch {
         Write-Log "Could not backup database $d to $databaseBackupFile" -Path $logFile -Level Error
     }
     catch {
         Write-Log "Could not backup database $d to $databaseBackupFile" -Path $logFile -Level Error


@@ -304,5 +308,7 @@ foreach($d in $databasesToBackup) {
     }
 }
 
     }
 }
 

+Invoke-FileRotation -Dir $configLogDir -MaxFiles $configLogRotate -Pattern $patternLogFile -LogFile $logFile
+

 $endTime = Get-Date -format "yyyy-MM-dd HH:mm:ss"
 Write-Log "Ended at $endTime" -Path $logFile
\ No newline at end of file
 $endTime = Get-Date -format "yyyy-MM-dd HH:mm:ss"
 Write-Log "Ended at $endTime" -Path $logFile
\ No newline at end of file