Hook for a git repository to add the current database dump to each commit

pre-commit

#!/bin/sh
#
# Creates a database dump right before committing and adds it to
# the commit. The database dump is splitted in two sql files, to
# the schema and data of the database.
#
# Called by "git commit" with no arguments.  The hook should
# exit with non-zero status after issuing an appropriate message if
# it wants to stop the commit.
#
# The file path is `.git/hooks/pre-commit` to make things working.
# If things are not working and you are in doubt, 
# run `chmod +x .git/hooks/pre-commit`.
# If you are running MAMP, use the path
# `/Applications/MAMP/Library/bin/mysqldump` for mysqldump.
#
# In order to create a git-optimized dump, a search-replace pattern
# inspired by https://stackoverflow.com/a/19961480 is implemented.
# However, this workaround for the Mac distributed version of sed was 
# implemented as well https://unix.stackexchange.com/a/135026
#
# To import the dump, use `mysql -u [user] -p[pass] mydb < mydb.sql`.
# Depending on your needs, you need to run this statement twice.
#
# Hint: Consider to add `!/var/sql/` to your `.gitignore`.
#

DBUSER=root
DBPASS=root
DBNAME=mydb
DBPATH=./var/sql
ARGS="--opt --complete-insert --skip-dump-date --hex-blob -u $DBUSER -p$DBPASS"

[[ -d $DBPATH ]] || mkdir $DBPATH

mysqldump --no-data --skip-add-drop-table $ARGS $DBNAME | sed 's/CREATE TABLE/CREATE TABLE IF NOT EXISTS/g' > $DBPATH/$DBNAME.schema.sql
mysqldump --no-create-info $ARGS $DBNAME | sed 's$VALUES ($VALUES\'$'\n  ($g' | sed 's$),($),\'$'\n  ($g' > $DBPATH/$DBNAME.data.sql

git add $DBPATH/$DBNAME.schema.sql
git add $DBPATH/$DBNAME.data.sql
exit 0