#!/bin/sh
DATE_DAY=`date +%Y-%m-%d`
DATE_YESTERDAY=`date +%Y-%m-%d --date '1 day ago'`

liste_fichiers=`ls /var/log/mysql | grep .0`

i=1
rm /home/backup/resultat.sql
for fichier in $liste_fichiers
do
		i=`expr $i + 1`
		echo "$i"
        echo "Fichier trouvé : $fichier"
		mysqlbinlog /var/log/mysql/$fichier -s --start-datetime=$DATE_YESTERDAY' 02:00:00' --stop-datetime=$DATE_DAY' 02:00:00' --result-file=/home/backup/result$i.sql
done

for j in `seq 1 $i`;
do
        echo $j
		cat /home/backup/result$j.sql >> /home/backup/resultat.sql
		echo >> /home/backup/resultat.sql
done

for k in `seq 1 $i`;
do
        echo $k
		rm /home/backup/result$k.sql
done

sed -i 's/aurora/aurora_reporting/g' /home/backup/resultat.sql