#!/bin/bash
#title          Daily mysql backup
#description    Mysql backup. Created to be scheduled.
#author         Dixon Chacon.

while getopts d:u:p: option
do
        case "${option}"
        in
                d) dbname=${OPTARG};;
                u) dbuser=${OPTARG};;
                p) dbpass=$OPTARG;;
        esac
done
#backup file
backup="/var/lib/mysql_backup/backup_`date +%u`.gz"

# creating backup
mkfifo /tmp/mysql_pipe
gzip -9 -c < /tmp/mysql_pipe  > "$backup" &
mysqldump "$dbname" -u "$dbuser" -p"$dbpass" > /tmp/mysql_pipe
rm /tmp/mysql_pipe
echo "Mysql backup done to $backup"