Git hooks mysql dump automatisation

config

#!/bin/sh

# db info
host="DBHOST"
user="DBUSER"
pass="DBPASS"
name="DBNAME"

# path info
project="/var/www/uneak"
dumppath="db_backup/dump"
dumpfile="oncommit-dump.sql"

# cmd
mysqldump="/usr/bin/mysqldump"
mysql="/usr/bin/mysql"

dumpoptions="--skip-extended-insert"

post-checkout + post-merge

#!/bin/sh
# 
#       Uneak 28/02/2016
#       Auto restore dump db on pull, merge, ou checkout
#


eval ". $(dirname "$0")/config" &&
echo "updating $name database"

if [ -z $pass ]
then
        eval "$mysql -h $host -u $user $name < $project/$dumppath/$dumpfile"
else
        eval "$mysql -h $host -u $user -p$pass $name < $project/$dumppath/$dumpfile"
fi &&


echo "$name database updated"
#exit 0

pre-commit

#!/bin/sh
# 
#       Uneak 28/02/2016
#       Auto dump db on commit
#


eval ". $(dirname "$0")/config" &&
echo "dumping $name database ..." &&

##
##
mkdir -p "$project/$dumppath" &&

if [ -z $pass ]
then
        eval "$mysqldump -h $host -u $user $dumpoptions $name > $project/$dumppath/$dumpfile"
else
        eval "$mysqldump -h $host -u $user -p$pass $dumpoptions $name > $project/$dumppath/$dumpfile"
fi &&


cd "$project" &&
git add "$dumppath/$dumpfile" &&
echo "$name database dumped" 
#exit 0

Change file permission :

sudo chmod +x .git/hooks/config
sudo chmod +x .git/hooks/pre-commit
sudo chmod +x .git/hooks/post-checkout
sudo chmod +x .git/hooks/post-merge