Skip to content

arvinkarimi2005/database_backup_cron

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

db-backups

how to use

bash backup.sh [-m | -p | -M ] [-h host] [-d dbname]

database types: -m : mongo -p : postgresql -M : mysql

-h : host of db

-d : database name

how to run

1- create backup user for each db and grant select privilage

2- credentials

  • create a .pgpass file in /home/user to store passwrods postgresql backup users
  • create .my.cnf file in /home/user to store mysql credentials
  • create .credential file for mongodb credential

3- make backup.sh runnable

    chmod +x backup.sh

4- modify crontab to run script

0 3 * * *  /bin/bash -c "/home/backup_user/backup.sh -p -h 172.20.1.12 -d db"
0 4 * * *  /bin/bash -c "/home/backup_user/backup.sh -p -h 172.20.1.3 -d anotherdb"
10 4 * * *  /bin/bash -c "/home/backup_user/backup.sh -p -h 172.20.1.18 -d another_postgres_db"
30 4 * * *  /bin/bash -c "/home/backup_user/backup.sh -p -h 172.20.1.18 -d defaultdb"
0 5 * * *  /bin/bash -c "/home/backup_user/backup.sh -m -h 172.20.1.16 -d mongo_db"
30 3 * * *  /bin/bash -c "/home/backup_user/backup.sh -M -h 172.20.1.53 -d mysql_db"
  • ensure that os user has permission to write in target folder
  • ensure that u have created a backup user for mongo on admin db

1- .pgpass sample

172.20.1.12:5432:db:user:password
172.20.1.3:5433:anotherdb:user:password
172.20.1.18:5434:another_postgres_db:user:password

2- .my.cnf sample

[mysqldump]
host = 172.20.1.53
port = 3306
user = backup
password = yourpassword

3- .credintial file sample

MONGO_USER=user
MONGO_PASSWORD=password

** of course you need each db client version for backups

1- mysql: apt install mysql-utilities mysql-client 2- mongodb: apt install mongodb-org-tools 3- postgres

About

bash script for daily database backups

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages