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