http://kb.owrench.com/index.php?action=history&feed=atom&title=Backup_of_files_and_DBBackup of files and DB - Revision history2026-05-04T04:27:22ZRevision history for this page on the wikiMediaWiki 1.34.2http://kb.owrench.com/index.php?title=Backup_of_files_and_DB&diff=71&oldid=previmported>Kishor at 11:27, 11 November 20162016-11-11T11:27:56Z<p></p>
<p><b>New page</b></p><div>'''DB Backups'''<br />
---------------------<br />
Backups of all the DBs are automated via cron and will be taken in the respective servers on a daily basis. <br><br />
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. <br><br />
Local system location of DB backups: /backup/ <br><br />
<br><br />
Most of the Dbs are downloaded daily and some are bi-weekly. <br><br />
Submit DVDs to accounts after writing.<br />
<br> <br><br />
'''Daily DB backups'''<br />
-------------------<br />
Hll | <br />
kailath | <br />
OandMongoing | <br />
kvvs(college) | <br />
jims | <br />
hindlabs | <br />
Hllacademy | <br />
Artisapp | <br />
March | <br />
ArtisWeb | <br />
Odoo | <br />
RPTS | <br />
Ddugky forum | <br />
Ddugky web | <br />
Call log manager | <br />
Ksebmedia | <br />
AGH (thumpi) | <br />
ISRT | <br />
PMTool (Troop) | <br />
Mantis | <br />
<br><br />
'''Bi-Weekly DB backup''' <br />
-------------------<br />
Seek | <br />
Purchase | <br />
Morais | <br />
Mist | <br />
OandMold | <br />
Steps<br />
<br> <br><br />
'''Google sheet for logging backups''': https://docs.google.com/spreadsheets/d/1J3Rbq1xt8Zv1n13Vy9By7ffxX-XEm5rQM672R1t6dJw/edit?ts=572823f8&pref=2&pli=1#gid=0 <br><br />
Sheet 1(''Annexure 1'')- Basic backup routine details <br><br />
Sheet 2(''Annexure 2'')- Log all backups here <br><br />
Sheet 3&4(''Annexure 3 & 4'')- Log DVD verification details (done by support) <br><br />
Sheet 5(''Annexure 5'')- Restorations done and checked by developers/testers are logged here(by them). <br><br />
<br />
<br />
========================================================================================================<br />
<br><br />
<br />
'''File backups'''<br />
------------------ <br><br />
The applications for which the file backup needs to be taken are provided in Annexure 2 of the google sheet. <br><br />
The files needs to be compressed and downloaded manually as there is no cron added for the same. <br><br />
Local system location of file backups: /data/Backup/ <br> <br><br />
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) <br> <br><br />
<br />
Note: There is a separate procedure for taking the FILE backup of Jims application, because of it's tremendous size. <br><br />
It is described in the wiki page http://192.168.1.103/mediawikisb/index.php/Jims_full_backup <br><br />
JIMS backup dvds are also needs to be numbered and submitted in accounts.<br> <br />
<br />
[[category:it-support]]</div>imported>Kishor