1234567891011121314151617181920212223242526272829 |
- #!/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
|