X-Git-Url: https://git.p6c8.net/psmysqlbackup.git/blobdiff_plain/8b6c416063774aa0d763cfb0809d63ad5aa48511..40caefe7cfe8b50dce073ab63f2ea094a1f94100:/psmysqlbackup.ps1?ds=inline diff --git a/psmysqlbackup.ps1 b/psmysqlbackup.ps1 index ce17ca3..9f6b4e9 100644 --- a/psmysqlbackup.ps1 +++ b/psmysqlbackup.ps1 @@ -25,12 +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 -$configRotate = 7 +$configBackupRotate = 7 # 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 $configRotate +# You should set this to at least the same as $configBackupRotate $configLogRotate = 7 # Databases to backup, leave empty to backup all databases @@ -213,6 +213,9 @@ function Invoke-FileRotation { $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" @@ -294,7 +297,7 @@ foreach($d in $databasesToBackup) { 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 @@ -305,7 +308,7 @@ foreach($d in $databasesToBackup) { } } -Invoke-FileRotation -Dir $configLogDir -MaxFiles $configLogRotate -Pattern "^log-\d{8,}-\d{6}\.log$" -LogFile $logFile +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