#!/bin/bash

 
# Linux bin paths, change this if it can not be autodetected via which command
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
GZIP="$(which gzip)"
# Get hostname
HOST="$(hostname)"
 
# File to store current backup file
FILE=""
 
# Get all database list first , if you want to backup all DBS
# DBS="$($MYSQL -Bse 'show databases')"
# Store list of databases
DBS="limesurvey
limesurvey2
cms1
"
# Get all database list first
#DBS="$($MYSQL -Bse 'show databases')"

echo "Backup of DBs"
for db in $DBS
do
    dbnew="zzbak_last_$db"
    $MYSQLDUMP  --databases $db  > $HOME/backupsql/$db.sql
    echo "DROP DATABASE IF EXISTS ${dbnew}" | $MYSQL
    echo "CREATE DATABASE ${dbnew}"  | $MYSQL
    $MYSQL $dbnew < $HOME/backupsql/$db.sql
done