From: Patrick Canterino <patrick@patrick-canterino.de>
Date: Thu, 23 Feb 2023 19:13:01 +0000 (+0100)
Subject: Implemented simple compression of dump files
X-Git-Url: https://git.p6c8.net/psmysqlbackup.git/commitdiff_plain/87eb6ff9504870c76833e19ee20a42c199a3913e?ds=sidebyside;hp=d904200840e55a663bc3b6b1a01cfb3f40b9db47

Implemented simple compression of dump files

Limited to 2 GB due to limitations of Compress-Archive
---

diff --git a/TODO.md b/TODO.md
index e26b5fc..717b82b 100644
--- a/TODO.md
+++ b/TODO.md
@@ -9,6 +9,6 @@
 - [ ] Configuration file
 - [ ] Pass configuration file by command line
 - [x] Write log file
-- [ ] Compress backups
+- [x] Compress backups
 - [ ] Add comments
 - [ ] Add README
\ No newline at end of file
diff --git a/psmysqlbackup.ps1 b/psmysqlbackup.ps1
index a99e18a..6177abd 100644
--- a/psmysqlbackup.ps1
+++ b/psmysqlbackup.ps1
@@ -27,6 +27,9 @@ $configBackupDir = 'backup'
 # Number of backups to keep, set to 0 to keep all backups
 $configBackupRotate = 7
 
+# Compress backups (limited to 2 GB due to usage of Compress-Archive)
+$configBackupCompress = $False
+
 # Directory where to store the logfiles
 $configLogDir = 'log'
 # Number of logfiles to keep, set to 0 to keep all logfiles
@@ -176,6 +179,11 @@ function Create-Backup([String]$database, [String]$target) {
     if($LastExitCode -ne 0) {
         throw "mysqldump exited with Exit code $LastExitCode"
     }
+
+    if($configBackupCompress) {
+        Compress-Archive -Path $target -DestinationPath "$target.zip"
+        Remove-Item -Path $target
+    }
 }
 function Invoke-FileRotation {
     Param (
@@ -211,7 +219,7 @@ function Invoke-FileRotation {
 
 $defaultDbExclude = @('information_schema', 'performance_schema')
 
-$patternBackupFile = '^backup-.+-\d{8,}-\d{6}\.sql$'
+$patternBackupFile = '^backup-.+-\d{8,}-\d{6}\.sql(\.zip)?$'
 $patternLogFile = '^log-\d{8,}-\d{6}\.log$'
 
 $currDaytime = Get-Date -format 'yyyyMMdd-HHmmss'
@@ -283,7 +291,12 @@ foreach($d in $databasesToBackup) {
 
     $databaseBackupFile = Join-Path -Path $databaseBackupDir -ChildPath "backup-$d-$currDaytime.sql"
 
-    Write-Log "Backing up $d to $databaseBackupFile..." -Path $logFile
+    if($configBackupCompress) {
+        Write-Log "Backing up $d to compressed file $databaseBackupFile.zip..." -Path $logFile
+    }
+    else {
+        Write-Log "Backing up $d to $databaseBackupFile..." -Path $logFile
+    }
     
     try {
         Create-Backup $d $databaseBackupFile