Created
December 8, 2014 08:59
-
-
Save brunob/68f48ddcf4205aec0b97 to your computer and use it in GitHub Desktop.
génération des fichiers de backup
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# Generation de la date du jour | |
date=$(date +%Y%m%d) | |
### | |
# Pamrametres du script | |
### | |
# Chemin du repertoire de la sauvegarde | |
chemin="/var/state/"$date | |
# Creation du dossier pour Backup, s'il existe, ignorer | |
mkdir $chemin 2> /dev/null; | |
# Prefixe des sauvegardes | |
prefixe="ks" | |
# Variables de connexion SQL | |
user="user" | |
host="localhost" | |
pass="mot_de_passe | |
### | |
# Backup SQL | |
### | |
# Options passees à MysqlDUMP | |
options="--add-drop-table --complete-insert" | |
# On construit la liste des bases de données | |
bases="$(mysql -u $user -h $host -p$pass -Bse 'show databases')" | |
# On lance le dump des bases | |
for db in $bases | |
do | |
mysqldump -u$user -h$host -p$pass $options $db | gzip > $chemin"/"$prefixe"-"$db"-"$date".sql.gz" | |
echo "["$(date +%F\ %X)"] Dump compressé dans "$chemin"/"$prefixe"-"$db"-"$date".sql.gz" | |
done | |
### | |
# Fichiers persos | |
### | |
backup_sites=$date"-sites.tar.gz" | |
tar -cvzf $chemin"/"$backup_sites /var/www/ --exclude "*/tmp/*" --exclude "*/local/*" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment