MySQL dump on pre-commit

git-pre-commit-mysql-dump.sh

#!/bin/bash

# Pre-commit hook to make a mysql dump right before committing and add it to the commit.
#
# Change the following values to suit your local setup.
# Add this file on your .git/hooks/ and name it as 'pre-commit'
#

# 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=sql

[[ -d $DBPATH ]] || mkdir $DBPATH
if [ -n $DBPASS ]; then
        echo mysqldump -u $DBUSER -p$DBPASS $DBNAME > $DBPATH/$DBNAME.sql
        mysqldump -u $DBUSER -p$DBPASS $DBNAME > $DBPATH/$DBNAME.sql
else
        mysqldump -u $DBUSER $DBNAME > $DBPATH/$DBNAME.sql
fi

git add $DBPATH/$DBNAME.sql
exit 0