#!/bin/sh
user_spn="smartpanda";
pass_spn="**********";
schema_spn="smartpanda";
user_mlv="maileva";
pass_mlv="**********";
schema_mlv="maileva";
user_fnb="fnb";
pass_fnb="**********";
schema_fnb="fnb";
#sp-yeoman-4

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

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

/usr/bin/mysqldump -u ${user_spn} -p${pass_spn} ${schema_spn} > ${dump_dir}smartpanda_${DATE_TRAIT_DHMS}.sql;
rc1=$?
/usr/bin/mysqldump -u ${user_mlv} -p${pass_mlv} ${schema_mlv} > ${dump_dir}maileva_${DATE_TRAIT_DHMS}.sql;
rc2=$?
/usr/bin/mysqldump -u ${user_fnb} -p${pass_fnb} ${schema_fnb} > ${dump_dir}fnb_${DATE_TRAIT_DHMS}.sql;
rc3=$?
#sp-yeoman-5

if [ $rc1 = 0 ]; then
  echo "_______________________________________________________";
  echo " Le dump spn est OK";
else
  echo "_______________________________________________________";
  echo " Le dump spn est KO";
fi
if [ $rc2 = 0 ]; then
  echo "_______________________________________________________";
  echo " Le dump mlv est OK";
else
  echo "_______________________________________________________";
  echo " Le dump mlv est KO";
fi
if [ $rc3 = 0 ]; then
  echo "_______________________________________________________";
  echo " Le dump fnb est OK";
else
  echo "_______________________________________________________";
  echo " Le dump fnb est KO";
fi
#sp-yeoman-6