X-Git-Url: https://git.p6c8.net/psmysqlbackup.git/blobdiff_plain/d855a7a04681f4a575956f0bee6a03654f12d99d..ac3854af1a50a24ad787fca5b3c250d7f8563e78:/psmysqlbackup.ps1?ds=sidebyside diff --git a/psmysqlbackup.ps1 b/psmysqlbackup.ps1 index a33b144..9292ed4 100644 --- a/psmysqlbackup.ps1 +++ b/psmysqlbackup.ps1 @@ -1,3 +1,11 @@ +# PSMySQLBackup +# PowerShell script for backing up MySQL / MariaDB databases on Windows +# +# Author: Patrick Canterino +# WWW: https://www.patrick-canterino.de/ +# https://github.com/pcanterino/dsmonrot +# License: 2-Clause BSD License + # Config $configMysqlHost = "localhost" @@ -38,22 +46,22 @@ function Create-Backup([String]$database, [String]$target) { 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 - } - } + 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 + } + } } $defaultExclusions = @("information_schema", "performance_schema")