#!/bin/bash

# Database credentials
user=""
password=""
host=""
db_name=""

# Other options
backup_path=""
date=$(date +"%d-%b-%Y")

# Set default file permissions
umask 177

# Dump database into SQL file
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql