]> git.p6c8.net - psmysqlbackup.git/log
psmysqlbackup.git
21 months agoCreate-Backup -> Invoke-DatabaseBackup main
Patrick Canterino [Tue, 28 Feb 2023 19:24:28 +0000 (20:24 +0100)]
Create-Backup -> Invoke-DatabaseBackup

"Create" is no approved verb in PowerShell

21 months agoUpdated TODO
Patrick Canterino [Thu, 23 Feb 2023 19:15:43 +0000 (20:15 +0100)]
Updated TODO

21 months agoImplemented simple compression of dump files
Patrick Canterino [Thu, 23 Feb 2023 19:13:01 +0000 (20:13 +0100)]
Implemented simple compression of dump files

Limited to 2 GB due to limitations of Compress-Archive

2 years agoRemoved the full path to the CLI programs
Patrick Canterino [Tue, 25 Jan 2022 18:53:56 +0000 (19:53 +0100)]
Removed the full path to the CLI programs

2 years agoReplaced some double quotes by single quotes
Patrick Canterino [Tue, 25 Jan 2022 18:52:16 +0000 (19:52 +0100)]
Replaced some double quotes by single quotes

2 years agoRemoved console output 0.3
Patrick Canterino [Tue, 18 Jan 2022 18:21:17 +0000 (19:21 +0100)]
Removed console output

2 years agoRenamed $configRotate to $configBackupRotate
Patrick Canterino [Tue, 18 Jan 2022 18:18:30 +0000 (19:18 +0100)]
Renamed $configRotate to $configBackupRotate

2 years agoCreated variables for file regexes
Patrick Canterino [Tue, 18 Jan 2022 18:17:19 +0000 (19:17 +0100)]
Created variables for file regexes

2 years agoUpdated TODO 0.2
Patrick Canterino [Sat, 15 Jan 2022 18:43:56 +0000 (19:43 +0100)]
Updated TODO

2 years agoRotate logfiles
Patrick Canterino [Fri, 14 Jan 2022 19:37:08 +0000 (20:37 +0100)]
Rotate logfiles

2 years agoCreated a general function for rotating files
Patrick Canterino [Fri, 14 Jan 2022 19:18:10 +0000 (20:18 +0100)]
Created a general function for rotating files

We will use this file later on for rotating logfiles

2 years agoComments for new config options
Patrick Canterino [Fri, 14 Jan 2022 16:40:49 +0000 (17:40 +0100)]
Comments for new config options

2 years agoBegan to implement logging
Patrick Canterino [Thu, 13 Jan 2022 21:19:50 +0000 (22:19 +0100)]
Began to implement logging

Using Jason Wasser's logging function again:
https://www.powershellgallery.com/packages/MrAADAdministration/1.4/Content/Write-Log.ps1

2 years agoUpdated TODO
Patrick Canterino [Thu, 13 Jan 2022 20:46:47 +0000 (21:46 +0100)]
Updated TODO

2 years agoUpdated README
Patrick Canterino [Mon, 10 Jan 2022 18:44:01 +0000 (19:44 +0100)]
Updated README

2 years agoAdded comments, especially for config
Patrick Canterino [Mon, 10 Jan 2022 18:29:45 +0000 (19:29 +0100)]
Added comments, especially for config

2 years agoCatch exception when creating a directory for a database backup 0.1
Patrick Canterino [Sat, 1 Jan 2022 16:41:46 +0000 (17:41 +0100)]
Catch exception when creating a directory for a database backup

2 years agoMinor changes
Patrick Canterino [Sat, 1 Jan 2022 16:28:28 +0000 (17:28 +0100)]
Minor changes

2 years agoAdded skeleton of README file
Patrick Canterino [Thu, 30 Dec 2021 15:12:54 +0000 (16:12 +0100)]
Added skeleton of README file

2 years agoAllow to define exclusions based on regular expressions
Patrick Canterino [Thu, 30 Dec 2021 14:53:47 +0000 (15:53 +0100)]
Allow to define exclusions based on regular expressions

Also, the databases matching the exclusions defined in $configDbExclude are now
removed later in the script. This means that when backing up a selection of
databases, $configDbExclude does not apply.

2 years agoUpdated TODO
Patrick Canterino [Wed, 29 Dec 2021 12:50:12 +0000 (13:50 +0100)]
Updated TODO

2 years agoFixed URL in header
Patrick Canterino [Wed, 29 Dec 2021 12:48:57 +0000 (13:48 +0100)]
Fixed URL in header

2 years agoRenamed variables
Patrick Canterino [Wed, 29 Dec 2021 12:35:58 +0000 (13:35 +0100)]
Renamed variables

$configDbExclusions -> $configDbExclude
$defaultExclusions -> $defaultDbExclude

2 years agoBefore backing up a selection of database, check if the databases exist
Patrick Canterino [Wed, 29 Dec 2021 12:32:42 +0000 (13:32 +0100)]
Before backing up a selection of database, check if the databases exist

2 years agoRotate only if mysqldump succeeded
Patrick Canterino [Tue, 28 Dec 2021 18:52:15 +0000 (19:52 +0100)]
Rotate only if mysqldump succeeded

2 years agoAdded comment in header of script file
Patrick Canterino [Tue, 28 Dec 2021 18:38:08 +0000 (19:38 +0100)]
Added comment in header of script file

2 years agoFixed indentations
Patrick Canterino [Tue, 28 Dec 2021 18:35:47 +0000 (19:35 +0100)]
Fixed indentations

2 years agoCheck exit codes of mysql and mysqldump
Patrick Canterino [Tue, 28 Dec 2021 18:32:47 +0000 (19:32 +0100)]
Check exit codes of mysql and mysqldump

2 years agoUpdated TODO
Patrick Canterino [Tue, 28 Dec 2021 12:48:59 +0000 (13:48 +0100)]
Updated TODO

2 years agoUpdated TODO
Patrick Canterino [Tue, 28 Dec 2021 12:41:27 +0000 (13:41 +0100)]
Updated TODO

2 years agoRemoved type definitions of config variables
Patrick Canterino [Tue, 28 Dec 2021 12:39:56 +0000 (13:39 +0100)]
Removed type definitions of config variables

2 years agoFixed backup exclusions and allow only to backup a selection of databases
Patrick Canterino [Tue, 28 Dec 2021 12:32:38 +0000 (13:32 +0100)]
Fixed backup exclusions and allow only to backup a selection of databases

2 years agoAllow to define databases to exclude from backup
Patrick Canterino [Tue, 28 Dec 2021 12:06:04 +0000 (13:06 +0100)]
Allow to define databases to exclude from backup

2 years agoAllow to define port for MySQL
Patrick Canterino [Tue, 28 Dec 2021 11:58:06 +0000 (12:58 +0100)]
Allow to define port for MySQL

2 years agoAdded rotation of backups
Patrick Canterino [Mon, 27 Dec 2021 19:16:05 +0000 (20:16 +0100)]
Added rotation of backups

2 years agoAdded license file
Patrick Canterino [Mon, 27 Dec 2021 12:11:25 +0000 (13:11 +0100)]
Added license file

2 years agoChanged creation of backup files
Patrick Canterino [Mon, 27 Dec 2021 12:05:34 +0000 (13:05 +0100)]
Changed creation of backup files

- Every database has its own directory
- Every backup file has a timestamp in its filename

2 years agoChanged config variables to CamelCase
Patrick Canterino [Mon, 27 Dec 2021 11:59:46 +0000 (12:59 +0100)]
Changed config variables to CamelCase

2 years agoAdded first version of the script
Patrick Canterino [Sun, 26 Dec 2021 20:34:17 +0000 (21:34 +0100)]
Added first version of the script

This is a very rudimentary version, you can only backup to the same file per
database

2 years agoAdded TODO
Patrick Canterino [Sun, 26 Dec 2021 20:32:41 +0000 (21:32 +0100)]
Added TODO

patrick-canterino.de