#!/usr/bin/env bash

V_DIR_SQL="/home/sysadmin/data"
V_DIR_BACKUP="/home/sysadmin/backup"

V_HOST="localhost"
V_DATABASE="database"
V_USER="root"
V_PASSWORD="root"

I_HOST="homologacao"
I_USER="sysadmin"

echo ".............................."
echo $(date)
echo " - "

echo "Starting dump .......... ready"
START=$(date +%s)

echo " 1/5"
echo -n "Dumping functions"
mysqldump --login-path=user --skip-opt --no-create-info --add-drop-table --no-data --routines ${V_SOURCE} > ${V_DIR_SQL}/FUNCTION.sql
echo " ...... ready"

echo " 2/5 "
echo -n "Dumping views"
mysql --login-path=user INFORMATION_SCHEMA --skip-column-names --batch -e "SELECT table_name FROM tables WHERE table_type = 'VIEW' AND table_schema = '$V_SOURCE'" | xargs mysqldump -u ${V_USER} -p${V_PASSWORD} ${V_SOURCE} > ${V_DIR_SQL}/VIEW.sql
echo " .......... ready"

echo " 3/5 "
echo -n "Dumping tables"
mysql --login-path=user INFORMATION_SCHEMA --skip-column-names --batch -e "SELECT table_name FROM tables WHERE table_type = 'BASE TABLE' AND table_schema = '$V_SOURCE'" | xargs mysqldump -u ${V_USER} -p${V_PASSWORD} ${V_SOURCE} > ${V_DIR_SQL}/TABLE.sql
echo " ......... ready"

echo " 4/5"
echo -n "Ziping backup"
rm ${V_DIR_BACKUP}/backup.zip
zip -qrj ${V_DIR_BACKUP}/backup.zip ${V_DIR_SQL}
echo " .......... ready"

echo " 5/5"
echo -n "Sending file"
scp ${V_DIR_BACKUP}/backup.zip ${I_USER}@${I_HOST}:backup/ >> ${DIR}backup.log
echo " ........... ready"

END=$(date +%s)
TIME=$(( $END - $START ))

echo ".............................."
echo "Backup finished ($TIME seconds)"