#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 … Continue reading backup_db