exe_bash_2017.2018/backsql

32 lines
548 B
Bash
Executable File

#!/bin/bash
DBUSER=""
DBPASSWORD=""
CURDate=$(date "+%Y%m%d%H%M")
FileName=$CURDate$DBUSER
DIR="./"
DBHOST="" #--host=
if [ $# -gt 0 ] ; then
DIR=$1
fi
if [ ! -d $DIR ]; then
mkdir $DIR
fi
echo "Nom d'utilisateur"
read DBUSER #--user
unset DBPASSWORD #--password=
prompt="Mot de passe :"
while IFS= read -p "$prompt" -r -s -n 1 char
do
if [[ $char == $'\0' ]]
then
break
fi
prompt='*'
DBPASSWORD+="$char"
done
mysqldump --host=$DBHOST --user=$DBUSER --password=$DBPASSWORD --all-databases > "$DIR/$FileName.sql"