bonesoul · March 24, 2022 15:56
diff --git a/backup-db-to-git.sh b/backup-db-to-git.sh
 #!/bin/sh
 cd /var/www/YOURSITE.ORG
 date=`date +"%b-%d-%y-%H-%M-%S"`
 mysqldump -h SERVER_IP -u root -pPASSWORD --skip-extended-insert --skip-dump-date --databases DBNAME > db-backups/YOURSITE.ORG.sql
 git add -A
 git commit -m "Site backups for $date"
 git push
 git gc




diff --git a/crontab b/crontab
 # m h  dom mon dow   command
 1 0 * * * sh /var/www/YOURSITE.org/backup.sh
	#!/bin/sh
	cd /var/www/YOURSITE.ORG
	date=`date +"%b-%d-%y-%H-%M-%S"`
	mysqldump -h SERVER_IP -u root -pPASSWORD --skip-extended-insert --skip-dump-date --databases DBNAME > db-backups/YOURSITE.ORG.sql
	git add -A
	git commit -m "Site backups for $date"
	git push
	git gc
	# m h dom mon dow command
	1 0 * * * sh /var/www/YOURSITE.org/backup.sh