Script for dumping database. Can easily exclude multiple tables

mysqldump_script.sh

#!/bin/bash

# execute with bash (e.g. $ bash mysqldump_script.sh)

PASSWORD=XXXXXX
HOST=XXXXXX
USER=XXXXXX
DATABASE=databasename
TODAY="$(date +'%d-%m-%Y')"
DB_FILE="dump_$TODAY.sql"
EXCLUDED_TABLES=(
sys_log
sys_history
)

IGNORED_TABLES_STRING=''
for TABLE in "${EXCLUDED_TABLES[@]}"
do :
   IGNORED_TABLES_STRING+=" --ignore-table=${DATABASE}.${TABLE}"
done

echo "Dump DB & compress"
mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} --single-transaction --quick --lock-tables=false ${DATABASE} ${IGNORED_TABLES_STRING} | gzip -c > ${DB_FILE}.gz

#echo "Dump DB without compressing"
#mysqldump --host=${HOST} --user=${USER} --password=${PASSWORD} --single-transaction --quick --lock-tables=false ${DATABASE} ${IGNORED_TABLES_STRING} > ${DB_FILE}