Ampp3d Wordpress sync script - production to dev

ampp3d-fetchdb.sh

    #########################################################
    # Remote MySQL Backup and Download
    # Author: Brian Strickland
    #
    # 1) Log into a remote server
    # 2) Run a MySQL dump on a database
    # 3) Copies the dump to the local machine.
    #
    # You can use this for any database/server, just change
    # the top parameters.
    #########################################################

    # Remote server info
    remoteUser=william
    remoteHost=servername

    # DB Info
    dbUser=ampp3d
    dbPass=databasepassword
    dbHost=thedatabase.server.com
    dbName=ampp3d

    # Backup options
    backupName="$dbName"-$(date +"%Y%m%d-%H%M").sql
    backupPath=/home/william/"$backupName"
    downloadName=.

    # Login to remote computer and run backup.
    echo "Logging into $remoteHost…"
    ssh -l "$remoteUser" "$remoteHost" "

           # Run the mysql backup
           echo "Running MySQL backup.  This may take a while…"
           mysqldump --opt "$dbName" > "$backupPath"
           gzip "$backupPath"
           echo "Backup complete."

           # Close the session
           exit;
    "

    # Copy the new database backup from remote host to current computer.
    echo "Downloading $backupName.gz to $downloadName…"
    scp "$remoteUser"@"$remoteHost":"$backupPath".gz "$downloadName"
    echo "Download complete."
    gzip -cd "$backupName".gz | mysql ampp3d
    echo "Local DB overwritten."
    mysql ampp3d < ampp3d-fetchdb-patch.sql
    echo "Production to Dev SQL commands run"

    echo "Finished ampped import - remember to turn off minify and varnish plugins"