X-Git-Url: https://git.p6c8.net/psmysqlbackup.git/blobdiff_plain/36d893de15158ae59e2188c1a6669cbd99b5ea42..5c6da0259f912abfa73c72dbb01784ca4b69d7c9:/psmysqlbackup.ps1?ds=sidebyside diff --git a/psmysqlbackup.ps1 b/psmysqlbackup.ps1 index d5eacb1..3592213 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 @@ -200,8 +200,6 @@ function Invoke-FileRotation { } if($keepFilesCount -eq -1) { - Write-Output "Deleting file $($_.FullName)" - if($null -ne $LogFile) { Write-Log "Deleting file $($_.FullName)" -Path $LogFile } @@ -232,9 +230,6 @@ catch { Write-Log $_ -Path $logFile -Level Error Write-Log "Exiting" -Path $logFile -Level Error - Write-Output "Failed to get list of databases" - Write-Output $_ - exit 1 } @@ -249,7 +244,6 @@ if($configDbBackup -and $configDbBackup.count -gt 0) { } else { Write-Log "Not backing up database $cDb, because it does not exist" -Path $logFile -Level Warn - Write-Warning "Not backing up database $cDb, because it does not exist" } } } @@ -283,9 +277,6 @@ foreach($d in $databasesToBackup) { Write-Log $_ -Path $logFile -Level Error Write-Log "Exiting" -Path $logFile -Level Error - Write-Output "Failed to create directory $databaseBackupDir" - Write-Output $_ - exit 1 } } @@ -293,18 +284,14 @@ foreach($d in $databasesToBackup) { $databaseBackupFile = Join-Path -Path $databaseBackupDir -ChildPath "backup-$d-$currDaytime.sql" Write-Log "Backing up $d to $databaseBackupFile..." -Path $logFile - Write-Output "Backing up $d to $databaseBackupFile..." try { Create-Backup $d $databaseBackupFile - Invoke-FileRotation -Dir $databaseBackupDir -MaxFiles $configRotate -Pattern $patternBackupFile -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 Write-Log $_ -Path $logFile -Level Error - - Write-Output "Could not backup database $d to $databaseBackupFile" - Write-Output $_ } }