diff options
author | Thomas Lange <code@nerdmind.de> | 2016-12-25 10:56:32 +0100 |
---|---|---|
committer | Thomas Lange <code@nerdmind.de> | 2016-12-25 10:56:32 +0100 |
commit | ec78b22ae10782bc146f30fab2e0df09f2ce15c3 (patch) | |
tree | 2047ccf9d5bd123342c3ebac28028e58a87379ce /Bash/mysql-database-backup.sh | |
parent | 7eaddf4194142b3dd95f697dbca38791e2c16650 (diff) | |
download | snippets-ec78b22ae10782bc146f30fab2e0df09f2ce15c3.tar.gz snippets-ec78b22ae10782bc146f30fab2e0df09f2ce15c3.tar.xz snippets-ec78b22ae10782bc146f30fab2e0df09f2ce15c3.zip |
Quiet mode option for use in crontabs was added.
Diffstat (limited to 'Bash/mysql-database-backup.sh')
-rwxr-xr-x | Bash/mysql-database-backup.sh | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/Bash/mysql-database-backup.sh b/Bash/mysql-database-backup.sh index 39b0a3d..746f215 100755 --- a/Bash/mysql-database-backup.sh +++ b/Bash/mysql-database-backup.sh @@ -6,9 +6,21 @@ # This database backup script goes through each database (except the excluded # # databases in DATABASE_EXCLUDED) and creates a bzip2 compressed backup file. # # # +# OPTION [-q]: Enable quiet mode for use in crontab. # +# # #%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%# #=============================================================================== +# Parsing command-line arguments with the getopts shell builtin +#=============================================================================== +while getopts :q option +do + case $option in + q) ARGUMENT_QUIETMODE=true ;; + esac +done + +#=============================================================================== # Define database login credentials and excluded databases #=============================================================================== DATABASE_USERNAME="InsertYourUsernameHere" @@ -43,6 +55,6 @@ DATABASES=$(mysql --user="${DATABASE_USERNAME}" --password="${DATABASE_PASSWORD} # Loop through all database names and create compressed database backup #=============================================================================== for database in ${DATABASES}; do - echo "[INFO] Creating compressed backup for database ${database} [...]" + [ ! $ARGUMENT_QUIETMODE ] && echo "[INFO] Creating compressed backup for database ${database} [...]" mysqldump --lock-all-tables --user="${DATABASE_USERNAME}" --password="${DATABASE_PASSWORD}" "${database}" | bzip2 > $(printf "${DIRECTORY_FILE}" "${database}") done
\ No newline at end of file |