#!/bin/bash
export NCURSES_NO_UTF8_ACS=1
LC_PAPER=fr_FR.UTF-8
LC_ADDRESS=fr_FR.UTF-8
LC_MONETARY=fr_FR.UTF-8
LC_NUMERIC=fr_FR.UTF-8
LC_ALL=fr_FR.UTF-8
LC_TELEPHONE=fr_FR.UTF-8
LC_MESSAGES=fr_FR.UTF-8
LC_IDENTIFICATION=fr_FR.UTF-8
LC_COLLATE=fr_FR.UTF-8
LC_MEASUREMENT=fr_FR.UTF-8
LC_CTYPE=fr_FR.UTF-8
LC_TIME=fr_FR.UTF-8
LC_NAME=fr_FR.UTF-8
LANG=fr_FR.UTF-8
dtstring=$(date +"%d")
DATADIR=/var/lib/mysql
DIRS=(/var/lib/mysql/*)
BACKUP_DIR_FULL=/var/lib/mysql/BACKUPS/07/
BACKUP_DIR_BACK=/var/lib/mysql-back
BACKUP_DIR_WORKFOLDER=/var/lib/mysql-BACKUPS-WORKFOLDER/
BACKUP_DIR_INC=/var/lib/mysql/BACKUPS
HEIGHT=30
WIDTH=70
CHOICE_HEIGHT=4
BACKTITLE="Restauration Base de donnees Centreon"
TITLE="Restauration"
MENU="Choisir le mode de restauration : \n \n"
if [ -d "${BACKUP_DIR_WORKFOLDER}" ]; then
echo ""
echo "$(tput bold) $(tput setaf 1)"
echo " >>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Restauration bloque <<<"
echo " >>> <<<"
echo " >>> Faire une purge de l'ancien restauration <<<"
echo " >>> <<<"
echo " >>> ${BACKUP_DIR_BACK}"
echo " >>> &"
echo " >>> ${BACKUP_DIR_WORKFOLDER}"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput bold) $(tput setaf 1)"
echo "$(tput sgr0)"
exit 1;
fi
if [ -d "${BACKUP_DIR_BACK}/" ]; then
echo ""
echo "$(tput bold) $(tput setaf 1)"
echo " >>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Restauration bloque <<<"
echo " >>> <<<"
echo " >>> Faire une purge de l'ancien restauration <<<"
echo " >>> <<<"
echo " >>> ${BACKUP_DIR_BACK}"
echo " >>> &"
echo " >>> ${BACKUP_DIR_WORKFOLDER}"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput bold) $(tput setaf 1)"
echo "$(tput sgr0)"
exit 1;
fi
OPTIONS=("Jour" "valable pour les jours anterieur"
"Heure" "valable pour ce jour seulement")
CHOICE=$(dialog --clear --backtitle "$BACKTITLE" --title "$TITLE" --clear --cancel-label "sortir" --menu "$MENU" $HEIGHT $WIDTH $CHOICE_HEIGHT "${OPTIONS[@]}" 2>&1 >/dev/tty)
clear
case $CHOICE in
Jour)
clear
MODE="Jour"
;;
Heure)
clear
MODE="Heure"
;;
Sortir)
clear
MODE="sortir"
;;
$DIALOG_CANCEL)
clear
MODE="sortir"
;;
$DIALOG_ESC)
clear
MODE="sortir"
;;
esac
if [ ${MODE} = "Heure" ]; then
DATE_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/07/" | cut -c9,10)
if [ ${DATE_BACKUP_DAY} = ${dtstring} ]; then
FULL_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/07/" | cut -c9,10)
A_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/08/" | cut -c9,10)
B_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/09/" | cut -c9,10)
C_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/10/" | cut -c9,10)
D_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/11/" | cut -c9,10)
E_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/12/" | cut -c9,10)
F_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/13/" | cut -c9,10)
G_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/14/" | cut -c9,10)
H_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/15/" | cut -c9,10)
I_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/16/" | cut -c9,10)
J_BACKUP_DAY=$(stat -c %y "/var/lib/mysql/BACKUPS/17/" | cut -c9,10)
if [ ${A_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="08 Restauration_a_08_heures OFF "
fi
if [ ${B_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="09 Restauration_a_09_heures OFF "
fi
if [ ${C_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="10 Restauration_a_10_heures OFF "
fi
if [ ${D_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="11 Restauration_a_11_heures OFF "
fi
if [ ${E_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="12 Restauration_a_12_heures OFF "
fi
if [ ${F_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="13 Restauration_a_13_heures OFF "
fi
if [ ${G_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="14 Restauration_a_14_heures OFF "
fi
if [ ${H_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="15 Restauration_a_15_heures OFF "
fi
if [ ${I_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="16 Restauration_a_16_heures OFF "
fi
if [ ${J_BACKUP_DAY} = ${dtstring} ]; then
CENTREON_MENU+="17 Restauration_a_17_heures OFF "
fi
RESTAURATION_HEURE=$(whiptail --title "Proposition de restauration" --radiolist \
"Quel restauration voulez-vous choisir ?" 25 50 11 \
"FULL" "Restauration_a_07_heures" ON \
${CENTREON_MENU} 3>&1 1>&2 2>&3)
exitstatus=$?
if [ $exitstatus = 0 ]; then
echo "Vous avez choisi le dossier de restauration :" ${RESTAURATION_HEURE}
else
echo "$(tput bold) $(tput setaf 2)"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Vous etes sortie du script de restauration"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
exit 1;
fi
if [ ${RESTAURATION_HEURE} == "FULL" ]; then
DATE_HEURE="7"
TEXTE="FULL seulement"
else
DATE_HEURE=${RESTAURATION_HEURE}
TEXTE="FULL + INCREMENTAL"
fi
dialog --title "Confirmation de restauration en mode heure" --backtitle "Confirmation de restauration en mode heure" --yesno "Etes-vous sur de vouloir restaurer la sauvegarde du jour a : ${DATE_HEURE} heures ( ${TEXTE} )" 7 55
# Get exit status
# 0 means user hit [yes] button.
# 1 means user hit [no] button.
# 255 means user hit [Esc] key.
response=$?
case $response in
0) echo "Lancement restauration";;
1) exit 1;;
255) exit 1;;
esac
if [ ${RESTAURATION_HEURE} == "FULL" ]; then
service mysql stop
mkdir ${BACKUP_DIR_WORKFOLDER}
cp -r ${BACKUP_DIR_FULL}* ${BACKUP_DIR_WORKFOLDER}
innobackupex --apply-log ${BACKUP_DIR_WORKFOLDER}
[ ! -d ${BACKUP_DIR_BACK} ] && mkdir -p ${BACKUP_DIR_BACK}
dialog --title "Deplacement des fichiers pour BACK" --gauge "Fichier du deplace..." 10 75 < <(
n=${#DIRS[*]};
i=0
for f in "${DIRS[@]}"
do
PCT=$(( 100*(++i)/n ))
cat <<EOF
XXX
$PCT
Fichier du deplace "$f"...
XXX
EOF
cp -r $f ${BACKUP_DIR_BACK} &>/dev/null
done
)
#cp -r /var/lib/mysql ${BACKUP_DIR_BACK}
if [ -d "/var/lib/mysql/lost+found/" ]; then
rm -rf /var/lib/mysql/lost+found/*
rm -rf /var/lib/mysql/lost+found/
fi
if [ -d "/var/lib/mysql/centreon/" ]; then
rm -rf /var/lib/mysql/centreon/*
rm -rf /var/lib/mysql/centreon/
fi
if [ -d "/var/lib/mysql/centreon_storage/" ]; then
rm -rf /var/lib/mysql/centreon_storage/*
rm -rf /var/lib/mysql/centreon_storage/
fi
if [ -d "/var/lib/mysql/mysql/" ]; then
rm -rf /var/lib/mysql/mysql/*
rm -rf /var/lib/mysql/mysql/
fi
if [ -d "/var/lib/mysql/performance_schema/" ]; then
rm -rf /var/lib/mysql/performance_schema/*
rm -rf /var/lib/mysql/performance_schema/
fi
if [ -d "/var/lib/mysql/test/" ]; then
rm -rf /var/lib/mysql/test/*
rm -rf /var/lib/mysql/test/
fi
rm -f /var/lib/mysql/*
innobackupex --force-non-empty-directories --copy-back ${BACKUP_DIR_WORKFOLDER}
chown -R mysql:mysql ${DATADIR}
chown -R mysql:mysql ${DATADIR}/*
chmod 0755 *
service mysql start
echo "Restauration termine"
echo ""
echo "$(tput bold) $(tput setaf 3)"
echo " >>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Penser a faire un reboot de la machine <<<"
echo " >>> <<<"
echo " >>> Penser a regenerer les POLLER <<<"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
else
service mysql stop
mkdir ${BACKUP_DIR_WORKFOLDER}
cp -r ${BACKUP_DIR_FULL}* ${BACKUP_DIR_WORKFOLDER}
innobackupex --apply-log --redo-only ${BACKUP_DIR_WORKFOLDER} --incremental-dir=${BACKUP_DIR_INC}/${RESTAURATION_CENTREON}
innobackupex --apply-log ${BACKUP_DIR_WORKFOLDER} --incremental-dir=${BACKUP_DIR_INC}/${RESTAURATION_CENTREON}
innobackupex --apply-log ${BACKUP_DIR_WORKFOLDER}
[ ! -d ${BACKUP_DIR_BACK} ] && mkdir -p ${BACKUP_DIR_BACK}
dialog --title "Deplacement des fichiers pour BACK" --gauge "Fichier du deplace..." 10 75 < <(
n=${#DIRS[*]};
i=0
for f in "${DIRS[@]}"
do
PCT=$(( 100*(++i)/n ))
cat <<EOF
XXX
$PCT
Fichier du deplace "$f"...
XXX
EOF
cp -r $f ${BACKUP_DIR_BACK} &>/dev/null
done
)
#cp -r /var/lib/mysql ${BACKUP_DIR_BACK}
if [ -d "/var/lib/mysql/lost+found/" ]; then
rm -rf /var/lib/mysql/lost+found/*
rm -rf /var/lib/mysql/lost+found/
fi
if [ -d "/var/lib/mysql/centreon/" ]; then
rm -rf /var/lib/mysql/centreon/*
rm -rf /var/lib/mysql/centreon/
fi
if [ -d "/var/lib/mysql/centreon_storage/" ]; then
rm -rf /var/lib/mysql/centreon_storage/*
rm -rf /var/lib/mysql/centreon_storage/
fi
if [ -d "/var/lib/mysql/mysql/" ]; then
rm -rf /var/lib/mysql/mysql/*
rm -rf /var/lib/mysql/mysql/
fi
if [ -d "/var/lib/mysql/performance_schema/" ]; then
rm -rf /var/lib/mysql/performance_schema/*
rm -rf /var/lib/mysql/performance_schema/
fi
if [ -d "/var/lib/mysql/test/" ]; then
rm -rf /var/lib/mysql/test/*
rm -rf /var/lib/mysql/test/
fi
rm -f /var/lib/mysql/*
innobackupex --force-non-empty-directories --copy-back ${BACKUP_DIR_WORKFOLDER}
chown -R mysql:mysql ${DATADIR}
chown -R mysql:mysql ${DATADIR}/*
chmod 0755 *
service mysql start
echo "Restauration termine"
echo ""
echo "$(tput bold) $(tput setaf 3)"
echo " >>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Penser a faire un reboot de la machine <<<"
echo " >>> <<<"
echo " >>> Penser a regenerer les POLLER <<<"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
fi
elif [ ${MODE} != ${dtstring} ]; then
NON_BACKUP=$(dialog --clear --title 'Message erreur' --msgbox '\n Il n y a pas de sauvegarde a restaurer' 10 50 2>&1 >/dev/tty)
else
echo "$(tput bold) $(tput setaf 1)"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Vous etes sortie du script de restauration a la boucle 2"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
fi
elif [ ${MODE} = "Jour" ]; then
DIR_FULL=(/var/lib/mysql/BACKUP/*)
DIR_INC=(/var/lib/mysql/BACKUP/INC/*)
f=0
for dirnamefull in $(ls -d /var/lib/mysql/BACKUP/*); do
if [ -d ${dirnamefull} ]; then
if [ ${dirnamefull} != "/var/lib/mysql/BACKUP/LOGS" ]; then
if [ ${dirnamefull} != "/var/lib/mysql/BACKUP/INC" ]; then
CENTREON_MENU_TSM+="${dirnamefull} FULL OFF "
BACKUP_DIR_FULL=$(echo "${dirnamefull}" | rev | cut -c7,8 | rev)
g=0
for dirnameinc in $(ls -d /var/lib/mysql/BACKUP/INC/*); do
if [ -d ${dirnameinc} ]; then
if [ ${dirnameinc} != "/var/lib/mysql/BACKUP/LOGS" ]; then
if [ ${dirnameinc} != "/var/lib/mysql/BACKUP/INC" ]; then
BACKUP_DIR_INC=$(echo "${dirnameinc}" | rev | cut -c4,5 | rev)
if [ ${BACKUP_DIR_FULL} = ${BACKUP_DIR_INC} ] ; then
#echo "g : $((++g)) << ${dirnameinc}"
CENTREON_MENU_TSM+="${dirnameinc} INCREMENTAL OFF "
fi
fi
fi
fi
done
fi
fi
fi
done
RESTAURATION_JOUR=$(whiptail --title "Proposition de restauration" --radiolist \
"Quel restauration voulez-vous choisir ?" 30 80 11 \
"Choisir_le_bon_dossier" "a_restaurer" ON \
${CENTREON_MENU_TSM} 3>&1 1>&2 2>&3)
exit_status=$?
if [ ${exit_status} = 0 ]; then
echo "Vous avez choisi la distribution :" ${RESTAURATION_JOUR}
else
echo "$(tput bold) $(tput setaf 2)"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Vous etes sortie du script de restauration"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
exit 1;
fi
BACKUP_INFORMATION=$(echo "${RESTAURATION_JOUR}" | rev | cut -d'/' -f2 | rev)
if [ ${BACKUP_INFORMATION} == "INC" ]; then
BACKUP_INFORMATION_INC1=$(echo "${RESTAURATION_JOUR}" | rev | cut -d'-' -f2 | rev)
BACKUP_INFORMATION_INC2=$(echo "${RESTAURATION_JOUR}" | rev | cut -d'-' -f1 | rev)
if [ ${BACKUP_INFORMATION_INC2} == "06" ]; then
BACKUP_INFORMATION_INC1=$[${BACKUP_INFORMATION_INC1}-1]
fi
for dirnamefull in $(ls -d /var/lib/mysql/BACKUP/*); do
if [ -d ${dirnamefull} ]; then
if [ ${dirnamefull} != "/var/lib/mysql/BACKUP/LOGS" ]; then
if [ ${dirnamefull} != "/var/lib/mysql/BACKUP/INC" ]; then
BACKUP_INFORMATION_FULL=$(echo "${dirnamefull}" | rev | cut -d'-' -f3 | rev)
if [ ${BACKUP_INFORMATION_FULL} == ${BACKUP_INFORMATION_INC1} ]; then
TEMP=${dirnamefull}
fi
fi
fi
fi
done
TEXTE="FULL + INCREMENTAL"
elif [ ${BACKUP_INFORMATION} == "BACKUP" ] ; then
TEXTE="FULL seulement"
else
TEXTE="ERREUR INCONNU"
fi
dialog --title "Confirmation de restauration en mode jour" --backtitle "Confirmation de restauration en mode jour" --yesno "Etes-vous sur de vouloir restaurer la sauvegarde du : ${RESTAURATION_JOUR} - ( ${TEXTE} )" 7 55
# Get exit status
# 0 means user hit [yes] button.
# 1 means user hit [no] button.
# 255 means user hit [Esc] key.
response=$?
case $response in
0) echo "Lancement restauration";;
1) exit 1;;
255) exit 1;;
esac
if [ ${BACKUP_INFORMATION} == "BACKUP" ]; then
service mysql stop
mkdir ${BACKUP_DIR_WORKFOLDER}
cp -r ${RESTAURATION_JOUR}/* ${BACKUP_DIR_WORKFOLDER}
innobackupex --apply-log ${BACKUP_DIR_WORKFOLDER}
[ ! -d ${BACKUP_DIR_BACK} ] && mkdir -p ${BACKUP_DIR_BACK}
dialog --title "Deplacement des fichiers pour BACK" --gauge "Fichier du deplace..." 10 75 < <(
n=${#DIRS[*]};
i=0
for f in "${DIRS[@]}"
do
PCT=$(( 100*(++i)/n ))
cat <<EOF
XXX
$PCT
Fichier du deplace "$f"...
XXX
EOF
cp -r $f ${BACKUP_DIR_BACK} &>/dev/null
done
)
#cp -r /var/lib/mysql ${BACKUP_DIR_BACK}
if [ -d "/var/lib/mysql/lost+found/" ]; then
rm -rf /var/lib/mysql/lost+found/*
rm -rf /var/lib/mysql/lost+found/
fi
if [ -d "/var/lib/mysql/centreon/" ]; then
rm -rf /var/lib/mysql/centreon/*
rm -rf /var/lib/mysql/centreon/
fi
if [ -d "/var/lib/mysql/centreon_storage/" ]; then
rm -rf /var/lib/mysql/centreon_storage/*
rm -rf /var/lib/mysql/centreon_storage/
fi
if [ -d "/var/lib/mysql/mysql/" ]; then
rm -rf /var/lib/mysql/mysql/*
rm -rf /var/lib/mysql/mysql/
fi
if [ -d "/var/lib/mysql/performance_schema/" ]; then
rm -rf /var/lib/mysql/performance_schema/*
rm -rf /var/lib/mysql/performance_schema/
fi
if [ -d "/var/lib/mysql/test/" ]; then
rm -rf /var/lib/mysql/test/*
rm -rf /var/lib/mysql/test/
fi
rm -f /var/lib/mysql/*
innobackupex --force-non-empty-directories --copy-back ${BACKUP_DIR_WORKFOLDER}
chown -R mysql:mysql ${DATADIR}
chown -R mysql:mysql ${DATADIR}/*
chmod 0755 *
service mysql start
echo "Restauration termine"
echo ""
echo "$(tput bold) $(tput setaf 3)"
echo " >>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Penser a faire un reboot de la machine <<<"
echo " >>> <<<"
echo " >>> Penser a regenerer les POLLER <<<"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
elif [ ${BACKUP_INFORMATION} == "INC" ] ; then
service mysql stop
mkdir ${BACKUP_DIR_WORKFOLDER}
cp -r ${TEMP}/* ${BACKUP_DIR_WORKFOLDER}
innobackupex --apply-log --redo-only ${BACKUP_DIR_WORKFOLDER} --incremental-dir=${RESTAURATION_JOUR}
innobackupex --apply-log ${BACKUP_DIR_WORKFOLDER} --incremental-dir=${RESTAURATION_JOUR}
innobackupex --apply-log ${BACKUP_DIR_WORKFOLDER}
[ ! -d ${BACKUP_DIR_BACK} ] && mkdir -p ${BACKUP_DIR_BACK}
dialog --title "Deplacement des fichiers pour BACK" --gauge "Fichier du deplace..." 10 75 < <(
n=${#DIRS[*]};
i=0
for f in "${DIRS[@]}"
do
PCT=$(( 100*(++i)/n ))
cat <<EOF
XXX
$PCT
Fichier du deplace "$f"...
XXX
EOF
cp -r $f ${BACKUP_DIR_BACK} &>/dev/null
done
)
#cp -r /var/lib/mysql ${BACKUP_DIR_BACK}
if [ -d "/var/lib/mysql/lost+found/" ]; then
rm -rf /var/lib/mysql/lost+found/*
rm -rf /var/lib/mysql/lost+found/
fi
if [ -d "/var/lib/mysql/centreon/" ]; then
rm -rf /var/lib/mysql/centreon/*
rm -rf /var/lib/mysql/centreon/
fi
if [ -d "/var/lib/mysql/centreon_storage/" ]; then
rm -rf /var/lib/mysql/centreon_storage/*
rm -rf /var/lib/mysql/centreon_storage/
fi
if [ -d "/var/lib/mysql/mysql/" ]; then
rm -rf /var/lib/mysql/mysql/*
rm -rf /var/lib/mysql/mysql/
fi
if [ -d "/var/lib/mysql/performance_schema/" ]; then
rm -rf /var/lib/mysql/performance_schema/*
rm -rf /var/lib/mysql/performance_schema/
fi
if [ -d "/var/lib/mysql/test/" ]; then
rm -rf /var/lib/mysql/test/*
rm -rf /var/lib/mysql/test/
fi
rm -f /var/lib/mysql/*
innobackupex --force-non-empty-directories --copy-back ${BACKUP_DIR_WORKFOLDER}
chown -R mysql:mysql ${DATADIR}
chown -R mysql:mysql ${DATADIR}/*
chmod 0755 *
service mysql start
echo "Restauration termine"
echo ""
echo "$(tput bold) $(tput setaf 3)"
echo " >>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Penser a faire un reboot de la machine <<<"
echo " >>> <<<"
echo " >>> Penser a regenerer les POLLER <<<"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
fi
elif [ ${MODE} = "sortir" ]; then
echo "$(tput bold) $(tput setaf 2)"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Vous etes sortie du script de restauration"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
exit 1;
else
echo "$(tput bold) $(tput setaf 1)"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo " >>> <<<"
echo " >>> Vous etes sortie du script de restauration a la boucle 1"
echo " >>> <<<"
echo " >>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<"
echo "$(tput sgr0)"
fi