#!/bin/sh
date +'FORMAT'
date +'%m/%d/%Y' 
date +'%r'
backup_date=$(date +'%m_%d_%Y')
mkdir /var/www/html/DB_backup/BACKUP_TRACKING_CONNEXION/${backup_date}
chmod -R 777 /var/www/html/DB_backup/BACKUP_TRACKING_CONNEXION/${backup_date}
mysqldump -h localhost -u root --password=Zm9ybWEycGx1c3Bhc3Nzd29yZGVscHJvZA== db_el2016 tracking stat_connexion data_edition_el connexion cours_plannifier stag_individu > /var/www/html/DB_backup/BACKUP_TRACKING_CONNEXION/${backup_date}/tracking_connexion.sql
cd /var/www/html/DB_backup/BACKUP_TRACKING_CONNEXION/
zip -r ${backup_date}.zip ${backup_date}
rm -rf ${backup_date}
