#!/bin/sh
user_spn="smartpanda";
pass_spn="**********";
schema_spn="smartpanda";
user_fnb="fnb";
pass_fnb="**********";
schema_fnb="fnb";
#sp-yeoman-7

dump_dir="/home/dump/dumpPrdForInt/";
DATE_TRAIT_DHMS=`date +%Y%m%d_%Hh%M`;

case ${1} in
        smartpanda)
                user_bdd=${user_spn}
                pass_bdd=${pass_spn}
                schema_bdd=${schema_spn}
        ;;
        fnb)
                user_bdd=${user_fnb}
                pass_bdd=${pass_fnb}
                schema_bdd=${schema_fnb}

        ;;
        #sp-yeoman-8

        *)
                echo "Non géré";
                exit 1;
        ;;
esac

echo "    ";
echo "      Lancement du dump du schema"
echo "_______________________________________________________";

mysqldump -u ${user_bdd} -p${pass_bdd} ${schema_bdd} > ${dump_dir}${schema_bdd}_${DATE_TRAIT_DHMS}.sql;
rc1=$?
if [ $rc1 = 0 ]; then
  echo "_______________________________________________________";
  echo " Le dump est OK";
else
  echo "_______________________________________________________";
  echo " Le dump est KO";
fi