]> git.p6c8.net - psmysqlbackup.git/log
psmysqlbackup.git
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