summaryrefslogtreecommitdiffstats
path: root/Bash
diff options
context:
space:
mode:
authorThomas Lange <code@nerdmind.de>2016-01-14 23:04:59 +0100
committerThomas Lange <code@nerdmind.de>2016-01-14 23:04:59 +0100
commit9369e89d8ce6f2582219970f333e4b0c9c792793 (patch)
tree7cf18c9c736d92a99a800d11261ebe4587bc1da6 /Bash
parent49ae01e05ef5a68ad0d22f5b73992149409434a2 (diff)
downloadsnippets-9369e89d8ce6f2582219970f333e4b0c9c792793.tar.gz
snippets-9369e89d8ce6f2582219970f333e4b0c9c792793.tar.xz
snippets-9369e89d8ce6f2582219970f333e4b0c9c792793.zip
Option --lock-all-tables added
Diffstat (limited to 'Bash')
-rw-r--r--Bash/mysql-database-backup.sh2
1 files changed, 1 insertions, 1 deletions
diff --git a/Bash/mysql-database-backup.sh b/Bash/mysql-database-backup.sh
index 4190fdc..241f283 100644
--- a/Bash/mysql-database-backup.sh
+++ b/Bash/mysql-database-backup.sh
@@ -34,5 +34,5 @@ DATABASES=`mysql --user="${DATABASE_USERNAME}" --password="${DATABASE_PASSWORD}"
# Loop through all databases and create compressed dump
#===============================================================================
for database in ${DATABASES}; do
- mysqldump --user="${DATABASE_USERNAME}" --password="${DATABASE_PASSWORD}" "${database}" | bzip2 > $(printf "${DIRECTORY_FILE}" "${database}")
+ mysqldump --lock-all-tables --user="${DATABASE_USERNAME}" --password="${DATABASE_PASSWORD}" "${database}" | bzip2 > $(printf "${DIRECTORY_FILE}" "${database}")
done \ No newline at end of file