A short bash script that exports all databases into separate gzipped files in a chosen location.

db-backup.sh

#!/bin/bash

# Example usage
# --
# 
# ./db-backup.sh -u username -p password -t /target/

while getopts u:p:t: option
do
	case "${option}"
		in
			u) USER=${OPTARG};;
			p) PASSWORD=${OPTARG};;
			t) TARGET=${OPTARG};;
	esac
done

for D in `mysql -u $USER -p$PASSWORD -N -B -e 'show databases'`;
do
    echo "Backing up $D to $TARGET"
    mysqldump --skip-comments --compact -u $USER -p$PASSWORD $D | gzip -9 > $TARGET/$D.sql.gz
done;