Admin: 3 revisions imported

2016-04-06T20:03:19Z

3 revisions imported

New page

'''Introduction'''

The following script was written to provide a quick way to run a backup of the Request Tracker ''mysql'' database. This is a good tool for routine daily backups and can be run as part of the daily cron batch.

'''Requirements'''

<nowiki> I wrote this for Debain Sarge/Stable and it depends on having the exim4 mailer installed. I also requires that there is a ''tmp'' dir in /root. It also assumes that ''root'' (or what ever account the cron job will run as) will have DB access rights to the RT Database. </nowiki>

'''Caveat Emptor'''

This script is provided with no warranties expressed or implied. Use your own risk. Milage may vary.

'''TODO'''

* Add section to detect mailer and automatically set this envvar
* Add automatic tmpfile cleanup

<nowiki>#!/bin/bash
#
# backupRTDB.sh
#
# $Author: www-data $
# $Revision: 1.3 $
# $Id: backupRTDB,v 1.3 2006/04/10 15:48:21 www-data Exp $
#
# Runs a mysqldump backup of the contents of the
# RT Database.
#
# Into files named rtdb-main-{date}.tar.gz
# rtdb-attach-{date}.tar.gz
#
# This script assumes that root can login to mysql locally
# without a password. If you change this then you will need to revise
# the connection strings.
#

#
# Implementation Specific Variables
#
# You can change this to another directory for the tmp files.
# I don't like to dump in /tmp
SCRTMPDIR=/root/tmp/
MAILHEADER=$SCRTMPDIRrtbakfiles-mail
rtDB=###YOURRTDATABASENAME###
rtbakWATCHER=###YOUREMAIL###
MAILSERVER=###YOUREMAILSERVER###
rtUSER=###YOURRTUSERNAME###

#
# Script Variables
#
curday=`date +"%Y%m%d%H%M%S"`
backdir=/var/backups/rt/
mainprefn="rtdb-main-"
attachprefn="rtdb-attach-"
mainfullfn=$backdir$mainprefn$curday.gz
attachfullfn=$backdir$attachprefn$curday.gz
rtdbbakCHANGES_FILE=$SCRTMPDIRrtbakfiles
HOSTNAME=`/bin/hostname`
FQDN=`/bin/hostname -f`
rtMainTables="ACL Attributes CachedGroupMembers CustomFieldValues CustomFields GroupMembers \
Groups Links ObjectCustomFieldValues ObjectCustomFields Principals Queues ScripActions \
ScripConditions Scrips Templates Tickets Transactions Users sessions"

#
# Make/Verify target dirs
#
if [ ! -d $backdir ]; then
mkdir $backdir;
fi

if [ ! -d $SCRTMPDIR ]; then
mkdir $SCRTMPDIR;
fi

# do the Main backup
mysqldump $rtDB --opt $rtMainTables | gzip > $mainfullfn

# do the Attachment backup
mysqldump $rtDB --opt --default-character-set=binary Attachments | gzip > $attachfullfn

#create message file and send to watcher
if [ -s $CHANGES_FILE ] ; then
echo HELO $MAILSERVER > $MAILHEADER
echo MAIL FROM:root@$FQDN >> $MAILHEADER
echo RCPT TO:$rtbakWATCHER >> $MAILHEADER
echo DATA >> $MAILHEADER
echo Subject: $HOSTNAME - $curday - RT Database backup >> $MAILHEADER
echo Backup of files from the RT install on ${HOSTNAME}: >> $MAILHEADER
echo This file is located at: >> $MAILHEADER
echo ${HOSTNAME}:$mainfullfn >> $MAILHEADER
echo >> $MAILHEADER
echo . >> $MAILHEADER
echo QUIT >> $MAILHEADER
exim4 -bs < $MAILHEADER
fi

</nowiki>

[[MichaelErana]] <u>g33k (at) efamilynj.org</u>

BackupRTDB - Revision history

Admin: 3 revisions imported