laravel database helper bash function - to dump and login into mysql shell

laravel-db.sh

function laraveldbinfo() {
    HOST=`perl -lne 's/(?<!^#)DB_HOST=(.*)/\1/ or next; print' .env`
    NAME=`perl -lne 's/(?<!^#)DB_DATABASE=(.*)/\1/ or next; print' .env`
    USERNAME=`perl -lne 's/(?<!^#)DB_USERNAME=(.*)/\1/ or next; print' .env`
    PASSWORD=`perl -lne 's/(?<!^#)DB_PASSWORD=(.*)/\1/ or next; print' .env`
    BACKUP_NAME="$NAME-$(date +%Y%m%d-%s).sql"
    echo "password is $PASSWORD"
}

function laraveldblogin() {
    laraveldbinfo
    cmd="mysql -u $USERNAME -h $HOST $NAME -p" 
    echo $cmd && eval $cmd
}

function laraveldbdump() {
    cmd="mysqldump -u $USERNAME -h $HOST $NAME -p > $BACKUP_NAME"
    echo $cmd && eval $cmd
}