#!/bin/bash

DATE=`date +%Y-%m-%d.%H%M%S`
echo "Starting MySQL dump for replication $DATE"

mysqldump -u root -p --single-transaction --master-data --databases my_app --verbose | gzip -c > "mysql.master.$DATE.sql.gz"

echo "Dump complete"