mysql backup bash script

mysql_backup.sh

# list of databases to back up (all of them except information_schema, see below)
declare -a databases=("mydatabase" "mysql" "performance_schema")

# current day of week as a number from 1 to 7 starting monday
# for week of year use %V (for ISO weeks from 1 to 53)
day_num=$(date +%u)
echo backing up for day "$day_num"

# where the backups are written
cd /var/backups/mysql/daily

#
for dbname in "${databases[@]}"
do
  echo backing up "$dbname"
  mysqldump -l --databases "$dbname" --single-transaction --routines --triggers | gzip > "$dbname".$day_num.dump.gz
done

# special case; needs skip lock tables param
echo backing up information_schema
mysqldump -l --databases information_schema --single-transaction --routines --triggers --skip-lock-tables | gzip > information_schema."$day_num".dump.gz