#!/bin/bash
#
# Verify directory structure exists prior to running this job
#
BackUpDIR="/mnt/backup/daily/databases/";
TimeStamp=$(date +"%Y.%m.%d-%H:%M:%S");

# DBs list in format "db1 db2 db3 db4"
#
DBList="blog-db forum-db";

for DB in $DBList; 
do
  mysqldump $DB > $BackUpDIR$DB.$TimeStamp.sql;
  xz  $BackUpDIR$DB.$TimeStamp.sql
done