Backup of files and DB
DB Backups
Backups of all the DBs are automated via cron and will be taken in the respective servers on a daily basis.
DBs are firstly downloaded to local system (Filezilla is already configured in Sysadmin system) and are burned to DVDs by the end of a week.
Local system location of DB backups: /backup/
Most of the Dbs are downloaded daily and some are bi-weekly.
Submit DVDs to accounts after writing.
Daily DB backups
Hll |
kailath |
OandMongoing |
kvvs(college) |
jims |
hindlabs |
Hllacademy |
Artisapp |
March |
ArtisWeb |
Odoo |
RPTS |
Ddugky forum |
Ddugky web |
Call log manager |
Ksebmedia |
AGH (thumpi) |
ISRT |
PMTool (Troop) |
Mantis |
Bi-Weekly DB backup
Seek |
Purchase |
Morais |
Mist |
OandMold |
Steps
Google sheet for logging backups: https://docs.google.com/spreadsheets/d/1J3Rbq1xt8Zv1n13Vy9By7ffxX-XEm5rQM672R1t6dJw/edit?ts=572823f8&pref=2&pli=1#gid=0
Sheet 1(Annexure 1)- Basic backup routine details
Sheet 2(Annexure 2)- Log all backups here
Sheet 3&4(Annexure 3 & 4)- Log DVD verification details (done by support)
Sheet 5(Annexure 5)- Restorations done and checked by developers/testers are logged here(by them).
============================================================================================
File backups
The applications for which the file backup needs to be taken are provided in Annexure 2 of the google sheet.
The files needs to be compressed and downloaded manually as there is no cron added for the same.
Local system location of file backups: /data/Backup/
Backup files are written into the DB DVDs itself at the end of every week. (Logging into the google sheets needs to be done with exact DVD number)
Note: There is a separate procedure for taking the FILE backup of Jims application, because of it's tremendous size.
It is described in the wiki page http://192.168.1.103/mediawikisb/index.php/Jims_full_backup
JIMS backup dvds are also needs to be numbered and submitted in accounts.