From 9369e89d8ce6f2582219970f333e4b0c9c792793 Mon Sep 17 00:00:00 2001 From: Thomas Lange 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