Create-Backup -> Invoke-DatabaseBackup

[psmysqlbackup.git] / psmysqlbackup.ps1

diff --git a/psmysqlbackup.ps1 b/psmysqlbackup.ps1
index 8ecf827174f163b365479a6d419f21785205589e..b728bb01e24d00dd4753f92dee6ce0ee56e4120a 100644 (file)
--- a/psmysqlbackup.ps1
+++ b/psmysqlbackup.ps1
@@ -18,15 +18,18 @@ $configMysqlUser = 'backup'
 $configMysqlPassword = 'backup'
 
 # Path to MySQL CLI program
 $configMysqlPassword = 'backup'
 
 # Path to MySQL CLI program

-$configMysqlCli = 'C:\Program Files\MariaDB 10.5\bin\mysql.exe'
+$configMysqlCli = 'mysql.exe'

 # Path to mysqldump CLI program
 # Path to mysqldump CLI program

-$configMysqldumpCli = 'C:\Program Files\MariaDB 10.5\bin\mysqldump.exe'
+$configMysqldumpCli = 'mysqldump.exe'

 
 # Directory where to store the backups
 $configBackupDir = 'backup'
 # Number of backups to keep, set to 0 to keep all backups
 $configBackupRotate = 7
 
 
 # Directory where to store the backups
 $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
 # Directory where to store the logfiles
 $configLogDir = 'log'
 # Number of logfiles to keep, set to 0 to keep all logfiles


@@ -170,12 +173,17 @@ function Get-Databases() {
     return $databases
 }
 
     return $databases
 }
 

-function Create-Backup([String]$database, [String]$target) {
+function Invoke-DatabaseBackup([String]$database, [String]$target) {

     & $configMysqldumpCli --host=$configMysqlHost --port=$configMysqlPort --user=$configMysqlUser --password=$configMysqlPassword --single-transaction --result-file=$target $database
 
     if($LastExitCode -ne 0) {
         throw "mysqldump exited with Exit code $LastExitCode"
     }
     & $configMysqldumpCli --host=$configMysqlHost --port=$configMysqlPort --user=$configMysqlUser --password=$configMysqlPassword --single-transaction --result-file=$target $database
 
     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 (
 }
 function Invoke-FileRotation {
     Param (


@@ -211,7 +219,7 @@ function Invoke-FileRotation {
 
 $defaultDbExclude = @('information_schema', 'performance_schema')
 
 
 $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'
 $patternLogFile = '^log-\d{8,}-\d{6}\.log$'
 
 $currDaytime = Get-Date -format 'yyyyMMdd-HHmmss'


@@ -283,10 +291,15 @@ foreach($d in $databasesToBackup) {
 
     $databaseBackupFile = Join-Path -Path $databaseBackupDir -ChildPath "backup-$d-$currDaytime.sql"
 
 
     $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 {
     
     try {

-        Create-Backup $d $databaseBackupFile
+        Invoke-DatabaseBackup $d $databaseBackupFile

         Invoke-FileRotation -Dir $databaseBackupDir -MaxFiles $configBackupRotate -Pattern $patternBackupFile -LogFile $logFile
     }
     catch {
         Invoke-FileRotation -Dir $databaseBackupDir -MaxFiles $configBackupRotate -Pattern $patternBackupFile -LogFile $logFile
     }
     catch {