Last active
June 6, 2021 14:05
-
-
Save jabranr/d4939b2b48fdcadc74765a3ed04d8157 to your computer and use it in GitHub Desktop.
Automatic MySQL dump and backup to Git repo cron job
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
how is the git user configured?
I guess CRON_USER is the DB_USER.