username =  "username"
password = "password"
database = c2duo_db

#!/bin/sh

mysqldump -u"username" -p"password" --opt c2duo_db > /home/sh/c2duo_db-`date +%d%m%Y`.sql

cd /home/sh
tar -zcvf c2duo_db-`date +%d%m%Y`.tar.gz  *.sql

username="username"
password="password"
database="database"

#!/bin/sh

source /path/to/db.conf
cd /home/sh
dumpfile_name=$database-$(date +%d%m%Y).sql

mysqldump -u"$username" -p"$password" --opt "$database" > $dumpfile_name
gzip $dumpfile_name

#!/bin/sh

source "$1"
cd /home/sh
[...] # rest of script as above

#!/bin/sh

username="$1"
password="$2"
database="$3"
cd /home/sh
[...] # rest of script as above

s/username/joe/
s/password/secret/
s/database/c2duo_db/g

sed -f db.sed mysqlbackup.sh > joeSqlbackup.sh