#!/bin/bash

# to prevent password prompt by mysqldump create .my.cnf file in $HOME directory containing:
# [mysqldump]
# user=root
# password=rootpassword

now=$(date +"%Y%m%d%H%M%S")
bak_file="backup.$now.sql"
bak_file_gz="$bak_file.gz"

echo "Creating backup of all MySQL databases.."
time mysqldump --all-databases --single-transaction > "$bak_file"
tar zcvf "$bak_file_gz" "$bak_file"
rm "$bak_file"
echo "Backup file created: $bak_file_gz"