MYSQL_USER=username
MYSQL_PASS=password
MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
SQLSTMT="SELECT CONCAT(table_schema,'.',table_name)"
SQLSTMT="${SQLSTMT} FROM information_schema.tables"
SQLSTMT="${SQLSTMT} WHERE table_schema NOT IN"
SQLSTMT="${SQLSTMT} ('information_schema','mysql')"
mysql ${MYSQL_CONN} -ANe"${SQLSTMT}" > ListOfTables.txt

MYSQL_USER=username
MYSQL_PASS=password
MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
MYSQLDUMP_OPTIONS="--hex-blob --triggers"
do
    DB=`echo ${DBTB} | sed 's/./ /g' | awk '{print $1}'`
    TB=`echo ${DBTB} | sed 's/./ /g' | awk '{print $2}'`
    mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} ${DB} ${TB} | gzip > ${DB}_${TB}.sql.gz &
done
wait

MYSQL_USER=username
MYSQL_PASS=password
MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
COMMIT_COUNT=0
COMMIT_LIMIT=10
MYSQLDUMP_OPTIONS="--hex-blob --triggers"
for DBTB in `cat ListOfTables.txt`
do
    DB=`echo ${DBTB} | sed 's/./ /g' | awk '{print $1}'`
    TB=`echo ${DBTB} | sed 's/./ /g' | awk '{print $2}'`
    mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} ${DB} ${TB} | gzip > ${DB}_${TB}.sql.gz &
    (( COMMIT_COUNT++ ))
    if [ ${COMMIT_COUNT} -eq ${COMMIT_LIMIT} ]
    then
        COMMIT_COUNT=0
        wait
    fi
done
if [ ${COMMIT_COUNT} -gt 0 ]
then
    wait
fi

MYSQLDUMP_OPTIONS="--hex-blob --triggers --no-create-info"

MYSQL_USER=username
MYSQL_PASS=password
MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
MYSQLDUMP_OPTIONS="--hex-blob --routines --triggers --single-transaction"
mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} --all-databases | gzip > MySQLData.sql.gz

MYSQL_USER=username
MYSQL_PASS=password
MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
MYSQLDUMP_OPTIONS="--hex-blob --triggers --single-transaction"
do
    DB=`echo ${DBTB} | sed 's/./ /g' | awk '{print $1}'`
    TB=`echo ${DBTB} | sed 's/./ /g' | awk '{print $2}'`
    mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} ${DB} ${TB} | gzip > ${DB}_${TB}.sql.gz &
done
wait