mysqldump a database to gzip

mysqldumpgz

#!/bin/bash

usage="Usage: mysqldumpgz database_name username"

err[1]="Invalid command"

# Check for database name argument
if [ -z "$1" ]
then
  echo ${err[1]}
  echo "$usage"
  exit 1
else
  db_name=$1
fi

# Check for username argument
if [ -z "$2" ]
then
  echo ${err[1]}
  echo "$usage"
  exit 1
else
  username=$2
fi

`mysqldump ${db_name} --single-transaction -u ${username} -p | gzip -c | cat > ${db_name}-$(date +%Y%m%d%H%M%S).sql.gz`

Tip: decompress with gzip -dv [filepath]