Automatic MySQL dump and backup to Git repo cron job

mysql_backup_cron.sh

#!/bin/sh
#
# @author: Jabran Rafique <hello@jabran.me>
# @link: http://jabran.me/articles/automatic-database-backup-using-git-hosting/

# Set variables
FULLDATE      = $(date +"%Y-%d-%m %H:%M")
NOW           = $(date +"%Y-%m-%d-%H-%M")
MYSQL_DUMP    = `which mysqldump`
GIT           = `which git`
DB_NAME       = "foo"
CRON_USER     = "bar"
TEMP_BACKUP   = "latest_backup.sql"
BACKUP_DIR    = $(date +"%Y/%m")

# Check current Git status and update
${GIT} status
${GIT} pull origin HEAD

# Dump database
${MYSQL_DUMP} -u "$CRON_USER" $DB_NAME > $TEMP_BACKUP & 
wait

# Make backup directory if not exists (format: {year}/{month}/)
if [ ! -d "$BACKUP_DIR" ]; then
  mkdir -p $BACKUP_DIR
fi

# Compress SQL dump
tar -cvzf $BACKUP_DIR/$DB_NAME-$NOW-sql.tar.gz $TEMP_BACKUP

# Remove original SQL dump
rm -f $TEMP_BACKUP

# Add to Git and commit
${GIT} add -A
${GIT} commit -m "Automatic backup - $FULLDATE"
${GIT} push origin HEAD

how is the git user configured?

I guess CRON_USER is the DB_USER.

@ppazos Git is assumed configured on the server. About CRON_USER, see section Setup a cron user in the article.