#!/bin/bash
#
# Primjer:
# ./mysqldump -u busa -d database -p pass
# cron
# 0 */3 * * * cd /example/blabla && ./mysqldump -u user -d database -p pass

while getopts "u:d:p:" OPTION
do
     case $OPTION in
	    u)
             	user=$OPTARG
             	;;
		d)
             	database=$OPTARG
             	;;
		p)
             	pass=$OPTARG
             	;;
		?)
             	exit
             	;;
     esac
done

if [ "$user" == "" ]
then
	echo "No user";
	exit
fi

if [ "$database" == "" ]
then
	echo "No database";
	exit
fi

if [ "$pass" == "" ]
then
	echo "No pass";
	exit
fi

FILE=$database.sql.`date +"%Y%m%d"`

mysqldump --opt --user=${user} --password=${pass} ${database} > ${FILE}