Cron job for backup a database to github

Question

I created a cron job to create a dump of my mysql database and add it to my github repo. But it doesn’t push it to the master it works until the commit. But it doesn’t push it.

/usr/local/mysql/bin/mysqldump -u root -proot1234 core > ~/dbdump/dump.sql

cd ~/dbdump
git add dump.sql
git commit -m "test"
git push origin master

*/5 * * * * /Users/Anjula/test.sh

Did you get any error? Do you have origin setup for your repo? Try running `git remote -v` — Ankit Jindal, Jul 25 '20 at 04:11
@AnkitJindal I don’t get any errors if I run ```git status``` it says that I'm ahead 1 commit origin/master — Anjula Samarasinghe, Jul 25 '20 at 04:23
`git status` only says that your local copy is ahead by one commit. Also, look at this [link](https://stackoverflow.com/questions/16578520/git-push-not-working-inside-a-cron-job) — Kartikey Singh, Jul 25 '20 at 05:29
Seems you are trying to push to a repo that you don't have access — Jayasanka Weerasinghe, Jul 25 '20 at 06:31

score 0 · Accepted Answer · answered Jul 28 '20 at 03:09

0

The problem was I haven’t set up the ssh keys

answered Jul 28 '20 at 03:09

Anjula Samarasinghe

37
8

Cron job for backup a database to github

1 Answers1