# Mysql DUMP
#!/bin/bash

user="user"
password="pass"
host="localhost:port"
db_name="db_name"
backup_path="/home/ubuntu/path/"
date=$(date +"%d-%b-%Y")
# Set default file permissions
umask 177
mysqldump -u $user $password -h $host $db_name > $backup_path/$db_name-$date.sql

# Get current date formated
date=$(date +"%d-%b-%Y")