Git mysql schema on project commits

pre-commit

#!/bin/sh

#path to script: /path_to_git_repo/.git/hooks/pre-commit

#DB Details
DBHOST=localhost
DBUSER=myuser
DBPASS=mypass
DBNAME=test_dbname

#Path to mysqldump
MYSQLDUMP=/Applications/MAMP/Library/bin/mysqldump

#Path to repository
GITREPO=/Applications/MAMP/htdocs/gitwithdb
cd $GITREPO

#Where to save the sql file
mkdir -p $GITREPO/sqlSchema/

$MYSQLDUMP --compact --user=$DBUSER -p$DBPASS -d $DBNAME > $GITREPO/sqlSchema/schema.sql

git add sqlSchema/schema.sql

Applied from this StackOverflow answer: http://stackoverflow.com/a/5518976/249645