ppe21adm/restorebase
2021-03-30 11:53:39 +02:00

14 lines
396 B
Bash
Executable File

#!/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