backup_db

#AT@VPS Script Plugin - Backup Server and Upload to Cloud
 #!/bin/bash

 SERVER_NAME=ARROWTRAN_BACKUP_DB
 TIMESTAMP=$(date +"%F")
 BACKUP_DIR="/root/backup/$TIMESTAMP"
 MYSQL=/usr/bin/mysql
 MYSQLDUMP=/usr/bin/mysqldump
 SECONDS=0
 remote=bkremotedb

 mkdir -p "$BACKUP_DIR/mysql"

 echo "Starting Backup Database";
 databases=$MYSQL -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema|mysql)"
 for db in $databases; do
     $MYSQLDUMP --force --opt $db | gzip > "$BACKUP_DIR/mysql/$db.gz"
 done
 echo "Finished";
 echo '';

 
 size=$(du -sh $BACKUP_DIR | awk '{ print $1}')
 echo "Starting Uploading Backup";
 /usr/sbin/rclone move $BACKUP_DIR "$remote:$SERVER_NAME/$TIMESTAMP" >> /var/log/rclone.log 2>&1

 #Clean up
 rm -rf $BACKUP_DIR
 /usr/sbin/rclone -q --min-age 2w delete "$remote:$SERVER_NAME" #Remove all backups older than 2 week sua 5 day
 /usr/sbin/rclone -q --min-age 2w rmdirs "$remote:$SERVER_NAME" #Remove all empty folders older than 2 week sua 5d
 /usr/sbin/rclone cleanup "$remote:" #Cleanup Trash
 echo "Finished";
 echo '';

 duration=$SECONDS
 echo "Total $size, $(($duration / 60)) minutes and $(($duration % 60)) seconds elapsed."