#!/bin/bash
########STRING#########
DATE1=`date +"%d"`
DATE2=`date +"%d%m%y-%H"`
DBACKUP=/mnt/backup/tanggal
DDUMPDIR=$DBACKUP/$DATE1
DDUMPFILE=$DBACKUP/$DATE2
DBUSER=root
DBPASS=webdev072019!

######Create User based on Date####
echo "Create Folder based on Date 1-31"
for ((i=10; i<=31; i++))
do
mkdir -p $DBACKUP/$i
done

for ((i=1; i<=9; i++))
do
mkdir -p $DBACKUP/0$i
done

chmod 775 -R $DBACKUP
chgrp www-data -R $DBACKUP

mkdir -p /var/log/script-backup

#######Backup Mysql######
echo "Processing mysql backup..."
        mysqldump -u $DBUSER --password="$DBPASS" --all-databases  > $DDUMPDIR/$DATE2.sql
        cd $DDUMPDIR && tar -czvf $DATE2.tar.gz $DATE2.sql
        rm -rf $DATE2.sql

echo "Database backup Harian has been completed successfully."


0 0 * * 7 certbot renew --dry-run && service apache2 reload > /var/log/apache2/lets-renew.log
30 05 * * * /bin/bash /root/script-backup/mysqlharian.sh > /var/log/script-backup/mysqlhariansiang.log
45 16 * * * /bin/bash /root/script-backup/mysqlharian.sh > /var/log/script-backup/mysqlharianmalam.log
55 16 * * 7 /bin/bash /root/script-backup/mysqlmingguan.sh > /var/log/script-backup/mysqlmingguan.log