$ cat check_dir_existence.sh 

#!/bin/sh
# check directory existence

dir=/home/user/_bac/sql

if [ -d $dir ]
then
    echo YES
else
    echo NO
    mkdir -p $dir
exit 0;
fi
exit 0;