#!/bin/sh

##############################################################
#                                                            #
# Sauvegarde les fichiers d'un repertoire et les bases Mysql #
#                                                            #
##############################################################

# Parametrage 
WWW_BACKUP_DIRECTORY=/home/backup/www
MYSQL_BACKUP_DIRECTORY=/home/backup/mysql
LOG_FILE=/tmp/backup.log
WWW_DIRECTORY=/var/www

# Sauvegarde des fichiers
echo "[$(date +%d/%m/%Y-%H:%M)] Sauvegarde des fichiers" >> $LOG_FILE
mkdir $WWW_BACKUP_DIRECTORY/$(date "+%Y%m%d")
cp -R $WWW_DIRECTORY/* $WWW_BACKUP_DIRECTORY/$(date "+%Y%m%d") >> $LOG_FILE

# Sauvegarde des bases de donnees MYSQL (on exclue information_schema et performance_schema)
echo "[$(date +%d/%m/%Y-%H:%M)] Sauvegarde des bases MYSQL" >> $LOG_FILE
cd $MYSQL_BACKUP_DIRECTORY
DBS="$(mysql --defaults-file=/etc/mysql/debian.cnf -Bse 'show databases;' | grep -Ev '(information_schema|performance_schema)')"
for DB in $DBS
do
    echo " -> "$DB >> $LOG_FILE
    mysqldump --defaults-file=/etc/mysql/debian.cnf $DB | gzip > $MYSQL_BACKUP_DIRECTORY/${DB}_$(date "+%Y%m%d-%H%M%S").sql.gz
done