#!/bin/bash
DAT=$(date "+%u")
bdname="bdgsb2"
ssh root@ppe21 'echo  "use bdgsb2;"|mysql -u admin -padmin'
if [[ $? != 0 ]]; then
  ssh root@ppe21 'echo  "create database bdgsb2;"|mysql -u admin -padmin'
fi
if ! [[ -r gsbvisite-latest.sql.gz ]]; then
	echo "$0 : fichier gsbvisite-latest introuvable"
	exit 1
fi
zcat gsbvisite-latest.sql.gz | ssh root@ppe21 "mysql -u admin -padmin bdgsb2"
exit 0