#!/bin/sh

DATE="/bin/date +%d-%m-%Y"
NAME="$DATE.sql"

HOST=""
USER=""
PASSWORD=""
DATABASE=""

mysqldump -h $HOST -u $USER -p$PASSWORD $DATABASE > /your/path/$NAME

# If need copy to Dropbox cloud or other storage
# cp $NAME /your/path/Dropbox/your-path-backup-in-dropbox/$NAME