simple script for backup mysql databases

backup-databases.sh

#!/bin/bash

#create user for dump
#mysql> GRANT SHOW DATABASES, SELECT, LOCK TABLES, RELOAD ON *.* to dump@localhost IDENTIFIED BY 'dumppwd';
#mysql> FLUSH PRIVILEGES;

BACKUP_PATH=/mnt/mysqlbackup/dump

DBASE[0]=base1
DBASE[1]=base2
DBASE[2]=base3

COUNT=${#DBASE[@]}

# make backup directory
mkdir -p $BACKUP_PATH

# remove backup's older than 14 days
find $BACKUP_PATH -type f -ctime +13 -exec rm {} \;

#create dumps in cycle
INDEX=0
while [ "$INDEX" -lt "$COUNT" ]; do
  # make and archive database backup
  BACKUP_FILE=$BACKUP_PATH/${DBASE[$INDEX]}-`date +%Y-%m-%d`.sql.bz2
  mysqldump             \
    --skip-set-charset  \
    --user=dump         \
    -pdumppwd            \
    ${DBASE[$INDEX]} |  \
    bzip2 -9 > $BACKUP_FILE
  
  echo $BACKUP_FILE created
  
  INDEX=`expr $INDEX + 1`
done