#!/bin/bash
START_TIME=$(date +%s)

mkdir -p /var/backup
mkdir -p /var/backup/db

gdrivemount = "/gdrive"
gdrivepath = "backup"

user = "root"
password = "password"

date_format "+%Y%m%d-%H%M%S"
timestamp=$(date "+%Y%m%d-%H%M%S")
path="/var/backup/db"
filename="$timestamp.txt"
log=$path/$filename

find $path -type f -mtime +2 -delete >> $log

echo "$(date $date_format) | Script | started" >> $log

mkdir $path/$timestamp >> $log

for dbname in `echo show databases| mysql -u$user -p$password`; do
echo "$(date $date_format) | $dbname | Mysqldump start" >> $log
mysqldump -u$user -p$password $dbname > "$path/$timestamp/$dbname.sql"

echo "$(date $date_format) | $dbname | Compress by tar" >> $log
tar -cvjf $path/$timestamp/$dbname.tar.bz2 $path/$timestamp/$dbname.sql

echo "$(date $date_format) | $dbname | Delete .sql" >> $log
rm $path/$timestamp/$dbname.sql
done;

echo "$(date $date_format) | General | Collect tar to one" >> $log
tar -cvjf $path/$timestamp.tar.bz2 $path/$timestamp


echo "$(date $date_format) | General | Remove tables tar" >> $log
rm -r $path/$timestamp

echo "$(date $date_format) | Google Drive | Start mv to gdrive" >> $log
google-drive-ocamlfuse -label me $gdrivemount
mv $path/$timestamp.tar.bz2 $gdrivemount/$drivepath
find $gdrivemount/$drivepath -type f -mtime +21 -delete >> $log

END_TIME=$(date +%s)
ELAPSED_TIME=$(expr $END_TIME - $START_TIME)

echo "$(date $date_format) | General | Script finished" >> $log
echo "$(date $date_format) | General | Elapsed Time $(date -d $ELAPSED_TIME +%H:%M:%S)"  >> $log

mv $log $gdrivemount/$drivepath
fusermount -u $gdrivemount