Skip to content

Instantly share code, notes, and snippets.

@pushrax

pushrax/gist:c47efd7b4b704f99bfce

Created February 14, 2015 19:20
Show Gist options
  • Save pushrax/c47efd7b4b704f99bfce to your computer and use it in GitHub Desktop.
Save pushrax/c47efd7b4b704f99bfce to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. pushrax created this gist Feb 14, 2015.
    8 changes: 8 additions & 0 deletions gistfile1.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    #!/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"