backup_server.sh

#!/bin/bash
green='\e[0;32m'
darkred='\e[1;31m'
lightblue='\e[1;34m'
defaut='\033[0m'

today=$(date +%Y-%m-%d)
foldername_save="pi3"
folder_save="${HOME}/backup/${foldername_save}"
sqldump_filename="_dump_${today}.sql"


echo -e "${darkred}***SCRIPT TO BACKUP MYSQL & shared files***${defaut}"

mkdir -p $folder_save
# Restrict to current user because it contain some sensible data
chmod 760 $folder_save

# echo -e "\r\n${lightblue}1 # MySQL Dump${defaut}"
# ssh pi "mysqldump -u${MYSQL_USER} -p${MYSQL_PASSWORD} --all-databases > /tmp/dump.sql"
# mkdir $folder_save
# cd $folder_save
# mysqldump -u root -p"******" --all-databases  > mysql_$sqldump_filename


echo -e "\r\n${lightblue}Copy shared files for website${defaut}"

raspberry_cook_shared_save="${folder_save}/var/www/raspberry_cook/shared/"
mkdir -p $raspberry_cook_shared_save
rsync -a -v --recursive pi3:/var/www/raspberry_cook/shared/public $raspberry_cook_shared_save
rsync -a -v --recursive pi3:/var/www/raspberry_cook/shared/config $raspberry_cook_shared_save


echo -e "\r\n${lightblue}Copy Gitea${defaut}"

gitea_save="${folder_save}/home/pi/"
mkdir -p $gitea_save
rsync -a -v --recursive --delete pi3:/home/pi/gitea-repositories $gitea_save
rsync -a -v --recursive --delete pi3:/home/pi/gitea-repositories $gitea_save

echo -e "\r\n${lightblue}Copy Raspberry conf${defaut}"

rsync -a -v --recursive pi3:/etc $folder_save 2> /dev/null

echo -e "\r\n${green}** DONE **${defaut}"