BackupToBackblaze/MYSQL_B2/script_backu...

#!/bin/bash
## 
# Backup database with arhive

LOGFILE=/backup/cloud_backup/log/script_log_file_`date +%F_%H-%M`.log
BASEARHIVE=/backup/cloud_backup/data/db/woorder_py_db_`date +%F_%H-%M`.gz
#path to B2 files 
CLOUDPATHDB=FOLDER/db
CLOUDPATHMEDIA=FOLDER/media
#db config
PG_USER=USERNAME
PG_DB=DATABASE
PG_PASSWORD=PASSOWRD
PG_HOST=localhost
DB_PATH=/backup/cloud_backup/data/db/
#media data
MEDIAPATH=/var/www/data/
TARMEDIAPATH=/backup/cloud_backup/data/media/media_`date +%F_%H-%M`.tar.gz
TARMEDIADIRPATH=/backup/cloud_backup/data/media/
# log filelist
LOGPATH=/backup/cloud_backup/log
LOG_ERROR=/backup/cloud_backup/log/error.log

log(){
   message="$(date +"%y-%m-%d %T") $@"
   echo $message >> $LOGFILE
}

#Start
log "start script"
# dump db
log "start dump db"
/usr/bin/mysqldump -u$PG_USER -p$PG_PASSWORD -B $PG_DB | gzip -9 > $BASEARHIVE ##  uncomment if need dump logs ##  2> /home/support/cloud_backup/log/script_log_file.log
sleep 1m
# move database to cloud
log "moving db files"
/usr/sbin/rclone --log-file=$LOGPATH/log_`date +%F_%H-%M`_rclone.log move $DB_PATH cloud:$CLOUDPATHDB
2>> $LOG_ERROR
sleep 1m
# backup media files
log "arhive media files"
tar -czf $TARMEDIAPATH $MEDIAPATH
sleep 1m
# move files to cloud
log "moving media files"
/usr/sbin/rclone --log-file=$LOGPATH/log_`date +%F_%H-%M`_rclone.log move $TARMEDIADIRPATH cloud:$CLOUDPATHMEDIA  2>> $LOG_ERROR
sleep 5s
i=30 #days for save log file
log "delete old logs"
find $LOGPATH/ -type f -mtime +$i -print0 | xargs -0 rm -f
sleep 5s
log "stop script"