[rt-users] Backing up RT

[Max McGrath]

I forgot to mention, I also backup a few other files/folder critical to RT:

######################################
#       BACKUP DATABASES             #
######################################
mysqldump -u root rt3 > rt3_backup.sql
mysqldump -u root mysql > mysql_backup.sql
#mysqldump -u root information_schema > information_schema_backup.sql

######################################
#      COPY OTHER FILES/FOLDERS      #
######################################
cp /etc/aliases /opt/rt3/lib/RT/rt-backup/
cp /etc/apache2/httpd.conf /opt/rt3/lib/RT/rt-backup/
cp /opt/rt3/etc/RT_SiteConfig.pm /opt/rt3/lib/RT/rt-backup/
cp -r /opt/rt3/local/ /opt/rt3/lib/RT/rt-backup/

This way I have a copy of my e-mail addresses for my queues, my apache
config, my SiteConfig, and my whole local folder....
--
Max McGrath
Asst. Network Admin/Systems Specialist
Carthage College
262-552-5512
mmcgrath at carthage.edu


On Wed, Jan 5, 2011 at 6:45 AM, Andy Graybeal
<andy.graybeal at casanueva.com>wrote:

>  This is exactly what I do.  Is this a decent way to be doing it -- I've
>> always just assumed it was okay.  I do it hourly, and then SCP it to
>> another system.
>>
>> Should I be stopping mysql or anything  before doing the mysqldump?
>> --
>>
>
> Max,
> What made you do hourly dumps?   I'm thinking now instead of nightly, I
> should be doing hourly dumps like you.
>
> -Andy
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110105/99da1d7e/attachment.htm>