#!/bin/bash

# Configuration de base: datestamp e.g. YYYYMMDD

DATE=$(date +"%Y_%m_%d")

# Dossier où sauvegarder les backups (créez le d'abord!)

BACKUP_DIR="/backup/www"

# Identifiants MySQL

# MYSQL_USER="backup"

# MYSQL_PASSWORD="ZWBw5vprenJfPXS5"

# Commandes MySQL (aucune raison de modifier ceci)

# MYSQL=/usr/bin/mysql

# MYSQLDUMP=/usr/bin/mysqldump

# Bases de données MySQL à ignorer

# SKIPDATABASES="Database|information_schema|performance_schema|mysql"

# Nombre de jours à garder les dossiers (seront effacés après X jours)

RETENTION=14

# ---- NE RIEN MODIFIER SOUS CETTE LIGNE ------------------------------------------
#
# Create a new directory into backup directory location for this date

mkdir -p $BACKUP_DIR/$DATE

# Retrieve a list of all databases

databases=`$MYSQL -u$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "($SKIPDATABASES)"`

# Dumb the databases in seperate names and gzip the .sql file

tar -cvpzf "$BACKUP_DIR/$DATE/www.tar.gz" "/srv/daemon-data/fdc368cf-db15-4e0a-af5d-0a0fc0a90ab7"

# Remove files older than X days



find $BACKUP_DIR/* -mtime +$RETENTION -delete