imported>Kishor at 04:31, 3 January 2018

2018-01-03T04:31:14Z

New page

This page explains the steps to be carried out once a new application is setup and it's database needs to be backed up daily. 

1. Put the backup script in the live server depending on whether it's a postgres or mysql db and add a cron to run it daily. 
Example script: 
<blockquote>current_time=$(date "+%d-%m-%Y_%H:%M"); 
pg_dump -U ddugky_dbuser -h localhost -Ft ddugky_db2 -n public -x -O -f "mis.ddugky.co.in/databasebackup/ddugkymis_$current_time"."tar"; </blockquote>

2. Now, creata a ftp user whose home directory is the backup folder. 

3. Now, we need to create a script in our local system to download this backup file automatically. 
To do that, 
Create a new shell script file (say, appname_db.sh) inside /home/origami/backupscripts/ folder 
Example content, 
<blockquote>#!/bin/bash 
HOST='107.161.191.186' #IP Address of the remote server 
USER='dbbmis@mis.ddugky.co.in' #Username of ftp 
PASSWORD='WvloVGFK3BMys' #Password of ftp 
REMOTEFILENAME="ddugkymis_$(date +%d-%m-%Y)_*" #File name of backup file in server ddugkymis_01-01-2018_00:00.tar 
LOCALDIR="Ddugky" 
. downloadfile.sh </blockquote>

4. Now add the new above created file to the list of applications that are backed up daily. To do that, 
Open downloadfile.sh in the same folder and add ". appname_db.sh" without quotes, to the last line. Save the file. 

The backup will be downloaded automatically from the next day, once the cron runs. 

Note: make sure the backup file name format in the remote server and the script in local machine are same, otherwise the script will fail to find the file in the remote server. 

[[Category:it-support]]

Auto backups setup (DB) - Revision history

imported>Kishor at 04:31, 3 January 2018