diff options
| author | Thomas Lange <code@nerdmind.de> | 2016-01-14 23:04:59 +0100 |
|---|---|---|
| committer | Thomas Lange <code@nerdmind.de> | 2016-01-14 23:04:59 +0100 |
| commit | 9369e89d8ce6f2582219970f333e4b0c9c792793 (patch) | |
| tree | 7cf18c9c736d92a99a800d11261ebe4587bc1da6 | |
| parent | 49ae01e05ef5a68ad0d22f5b73992149409434a2 (diff) | |
| download | snippets-9369e89d8ce6f2582219970f333e4b0c9c792793.tar.gz snippets-9369e89d8ce6f2582219970f333e4b0c9c792793.tar.xz snippets-9369e89d8ce6f2582219970f333e4b0c9c792793.zip | |
Option --lock-all-tables added
| -rw-r--r-- | Bash/mysql-database-backup.sh | 2 |
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 |