#!/bin/bash

cd /home/nawn2219/public_html/transfert_pra
#********Decompression des bases de données
echo $(date +%F-%T)   "Decompression des bases de données" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log

cd /home/nawn2219/public_html/transfert_pra/bases
tar -xzvf `date +%Y%m%d`_08h00.tar.gz

#*******Traitement des bases de données
echo $(date +%F-%T)   "Traitement des bases de données" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log

cd /home/nawn2219/public_html/transfert_pra/bases/`date +%Y%m%d`
#mysql --host='localhost' --user='nawn2219_demouser' --password='Faw443wz!30' nawn2219_pra_effimaintenance< effimaintenance.sql
mysql --defaults-extra-file=../../../mysql_import.cnf nawn2219_pra_effimaintenance< effimaintenance.sql

cd ..
rm -r `date +%Y%m%d`

echo $(date +%F-%T)   "*****************FIN traitement ****************" >> /home/nawn2219/public_html/transfert_pra/logs/log_`date +%Y%m`.log