MySQL backup on post-merge

git-post-merge-mysql-update.sh

#!/bin/bash

# Post-merge hook to add a mysql db when post-merge occurs.
#
## Change the following values to suit your local setup.
# The name of a database user with read access to the database.
DBUSER=[dbuser]

# The password associated with the above user. Leave commented if none.
DBPASS=[dbpass]

# The database associated with this repository.
DBNAME=[dbname]

# The path relative to the repository root in which to store the sql dump.
DBPATH=[dbpath]

# Replace foreign url for new url
PROJECT=[project-name-url]
OLDURL=http://labs.blacksheepdesign.co.nz/$PROJECT/site
NEWURL=http://miguel.dev/$PROJECT/site

mysql -u $DBUSER -p$DBPASS $DBNAME < $DBPATH/$DBNAME.sql
wp search-replace $OLDURL $NEWURL