From 9369e89d8ce6f2582219970f333e4b0c9c792793 Mon Sep 17 00:00:00 2001
From: Thomas Lange <code@nerdmind.de>
Date: Thu, 14 Jan 2016 23:04:59 +0100
Subject: Option --lock-all-tables added

---
 Bash/mysql-database-backup.sh | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'Bash')

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
-- 
cgit v1.2.3