Backing up the system

RT Users
1

I have RT3 and MySQL installed on RHEL 4 and this is all I use this
server for. Does anyone have any guidelines on what I need to be
backing up to prevent losing my data if there is a crash?

Regards,
Bruce Rudd
Solutions Engineer

DataDirect Technologies

www.DataDirect.com http://www.datadirect.com/

Check and log cases on the web with SupportLink Online
http://www.datadirect.com/support/index.ssp
Interact with Peers and exchange information with our Developer’s Forums
http://forums.datadirect.com/ddforums/index.jspa
You may reach a SupportLink Engineer at (888) 332-6797

http://www.datadirect.com/designpreviews/index.ssp

2

I have RT3 and MySQL installed on RHEL 4 and this is all I use this server for. Does anyone have any guidelines on what I need to be backing up to prevent losing my data if there is a crash?

You need solution for backing up MySQL tables of InnoDB type.
Google is your friend.

Regards,
Bruce Rudd
Solutions Engineer

DataDirect Technologies

www.DataDirect.com

Check and log cases on the web with SupportLink Online
Interact with Peers and exchange information with our Developer’s Forums
You may reach a SupportLink Engineer at (888) 332-6797

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

3

Bruce Rudd wrote:

I have RT3 and MySQL installed on RHEL 4 and this is all I use this
server for. Does anyone have any guidelines on what I need to be
backing up to prevent losing my data if there is a crash?

Bruce,

We have RT3.4.4, MySQL Ver 4.1.9 on RHEL3U5. We use:

/usr/bin/mysqldump --add-drop-table --single-transaction --quick $DB >>
$FILENAME

for our nightly backups.

Best Regards,
Camron

Camron W. Fox
Hilo Office
High Performance Computing Group
Fujitsu America, INC.
E-mail: cwfox@us.fujitsu.com
Phone: (808) 934-4102
Cell: (808) 937-5026

4

Thanks,

That will help be back up the data but I guess what I mean to say is
that I also need a way to back up the binaries. I am not sure where all
the pieces may be hiding that I need to back up.

Regards,
Bruce Rudd
Solutions Engineer
DataDirect Technologies
www.DataDirect.com

Check and log cases on the web with SupportLink Online
Interact with Peers and exchange information with our Developer’s Forums
You may reach a SupportLink Engineer at (888) 332-6797From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Camron W.
Fox
Sent: Thursday, September 22, 2005 7:22 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Backing up the system

Bruce Rudd wrote:

I have RT3 and MySQL installed on RHEL 4 and this is all I use this
server for. Does anyone have any guidelines on what I need to be
backing up to prevent losing my data if there is a crash?

Bruce,

We have RT3.4.4, MySQL Ver 4.1.9 on RHEL3U5. We use:

/usr/bin/mysqldump --add-drop-table --single-transaction --quick $DB >>
$FILENAME

for our nightly backups.

Best Regards,
Camron

Camron W. Fox
Hilo Office
High Performance Computing Group
Fujitsu America, INC.
E-mail: cwfox@us.fujitsu.com
Phone: (808) 934-4102
Cell: (808) 937-5026

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

5

My guess would be in the /Opt/rt3 directory. But wouldn’t it be simpler to
keep a copy of the installation sources? If your system dies, you’re going
to have to reinstall the OS anyway. Just remember to keep the install
sources for any add-ins you have as well. Once you reinstall and get the
data directories reloaded, RT should go back to working just fine. At least
that’s been my experience in my disaster recovery testing.

Thanks
Tim Mahoney
Win Svr 2003 / RT 3.0.12 / Apache 1.33 / Perl 5.8.6 / MySQL 4.1.18From: Bruce Rudd [mailto:Bruce.Rudd@datadirect.com]
Sent: Friday, September 23, 2005 8:57 AM
To: cwfox@us.fujitsu.com; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Backing up the system

Thanks,

That will help be back up the data but I guess what I mean to say is that I
also need a way to back up the binaries. I am not sure where all the pieces
may be hiding that I need to back up.

Regards,
Bruce Rudd
Solutions Engineer
DataDirect Technologies
www.DataDirect.com

Check and log cases on the web with SupportLink Online Interact with Peers
and exchange information with our Developer’s Forums You may reach a
SupportLink Engineer at (888) 332-6797

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Camron W.
Fox
Sent: Thursday, September 22, 2005 7:22 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Backing up the system

Bruce Rudd wrote:

I have RT3 and MySQL installed on RHEL 4 and this is all I use this
server for. Does anyone have any guidelines on what I need to be
backing up to prevent losing my data if there is a crash?

Bruce,

We have RT3.4.4, MySQL Ver 4.1.9 on RHEL3U5. We use:

/usr/bin/mysqldump --add-drop-table --single-transaction --quick $DB >>
$FILENAME

for our nightly backups.

Best Regards,
Camron

Camron W. Fox
Hilo Office
High Performance Computing Group
Fujitsu America, INC.
E-mail: cwfox@us.fujitsu.com
Phone: (808) 934-4102
Cell: (808) 937-5026

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

6

Tim,

That is one option. But I would loose an customization I had and the
installation did not go without it’s problems the first time. I was not
sure if everything resided under /opt/rt3/

Regards,
Bruce Rudd
Solutions Engineer
DataDirect Technologies
www.DataDirect.com

Check and log cases on the web with SupportLink Online
Interact with Peers and exchange information with our Developer’s Forums
You may reach a SupportLink Engineer at (888) 332-6797From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Mahoney,
Tim
Sent: Friday, September 23, 2005 10:03 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Backing up the system

My guess would be in the /Opt/rt3 directory. But wouldn’t it be simpler
to
keep a copy of the installation sources? If your system dies, you’re
going
to have to reinstall the OS anyway. Just remember to keep the install
sources for any add-ins you have as well. Once you reinstall and get
the
data directories reloaded, RT should go back to working just fine. At
least
that’s been my experience in my disaster recovery testing.

Thanks
Tim Mahoney
Win Svr 2003 / RT 3.0.12 / Apache 1.33 / Perl 5.8.6 / MySQL 4.1.18

From: Bruce Rudd [mailto:Bruce.Rudd@datadirect.com]
Sent: Friday, September 23, 2005 8:57 AM
To: cwfox@us.fujitsu.com; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Backing up the system

Thanks,

That will help be back up the data but I guess what I mean to say is
that I
also need a way to back up the binaries. I am not sure where all the
pieces
may be hiding that I need to back up.

Regards,
Bruce Rudd
Solutions Engineer
DataDirect Technologies
www.DataDirect.com

Check and log cases on the web with SupportLink Online Interact with
Peers
and exchange information with our Developer’s Forums You may reach a
SupportLink Engineer at (888) 332-6797

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Camron W.
Fox
Sent: Thursday, September 22, 2005 7:22 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Backing up the system

Bruce Rudd wrote:

I have RT3 and MySQL installed on RHEL 4 and this is all I use this
server for. Does anyone have any guidelines on what I need to be
backing up to prevent losing my data if there is a crash?

Bruce,

We have RT3.4.4, MySQL Ver 4.1.9 on RHEL3U5. We use:

/usr/bin/mysqldump --add-drop-table --single-transaction --quick $DB >>
$FILENAME

for our nightly backups.

Best Regards,
Camron

Camron W. Fox
Hilo Office
High Performance Computing Group
Fujitsu America, INC.
E-mail: cwfox@us.fujitsu.com
Phone: (808) 934-4102
Cell: (808) 937-5026

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com
The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

7

We use the script below, I believe that all the binaries should be in two
locations, the base files path and then your ‘local’ customizations path.

#!/bin/bash

backupRT.sh

Runs a file level backup of the contents of the following

directories:

/usr/local/share/request-tracker3.4

/usr/share/request-tracker3.4

Into a file named rtappbak-{date}.tar.gz

Last Revision: August 11, 2005

curday=date +"%Y%m%d%H%M%S"
prefn=“rtappbak-”
fullfn=$prefn$curday.tgz
rtbakCHANGES_FILE=/root/tmp/rtbakfiles

You can change this to another directory for the tmp files.

I don’t like to dump in /tmp

fullFILENAME=pwd$fullfn

do the backup

tar cvzf $fullfn /usr/local/share/request-tracker3.4/usr/share/request-tracker$

#get the file list and send to $rtbakCHANGES_FILE
tar tvzf $fullfn > $rtbakCHANGES_FILEOn 9/23/05, Bruce Rudd Bruce.Rudd@datadirect.com wrote:

Thanks,

That will help be back up the data but I guess what I mean to say is
that I also need a way to back up the binaries. I am not sure where all
the pieces may be hiding that I need to back up.

Regards,
Bruce Rudd
Solutions Engineer
DataDirect Technologies
www.DataDirect.com http://www.DataDirect.com

Check and log cases on the web with SupportLink Online
Interact with Peers and exchange information with our Developer’s Forums
You may reach a SupportLink Engineer at (888) 332-6797

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Camron W.
Fox
Sent: Thursday, September 22, 2005 7:22 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Backing up the system

Bruce Rudd wrote:

I have RT3 and MySQL installed on RHEL 4 and this is all I use this
server for. Does anyone have any guidelines on what I need to be
backing up to prevent losing my data if there is a crash?

Bruce,

We have RT3.4.4, MySQL Ver 4.1.9 on RHEL3U5. We use:

/usr/bin/mysqldump --add-drop-table --single-transaction --quick $DB >>
$FILENAME

for our nightly backups.

Best Regards,
Camron

Camron W. Fox
Hilo Office
High Performance Computing Group
Fujitsu America, INC.
E-mail: cwfox@us.fujitsu.com
Phone: (808) 934-4102
Cell: (808) 937-5026

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

8

That is one option. But I would loose an customization I had and the
installation did not go without it’s problems the first time. I was not
sure if everything resided under /opt/rt3/

You’d have to install all the needed perl modules again and fix your
httpd.conf besides having the database and things under /opt/rt3.
I like to have backuppc (http://backuppc.sourceforge.net/) running
on another machine making nightly copies of everything because it
is painless and it’s really easy to grab a few files back through
the web interface. It is also possible to get full tar images back and
thus do a full restore, although that isn’t completely automated.

Les Mikesell
les@futuresource.com

9

Les,

That is what I am looking at doing. Well, having IT do for me anyway.
I am just not sure what all the location are for all of the pieces I
need to backup.

Regards,
Bruce Rudd
Solutions Engineer
DataDirect Technologies
www.DataDirect.com

Check and log cases on the web with SupportLink Online
Interact with Peers and exchange information with our Developer’s Forums
You may reach a SupportLink Engineer at (888) 332-6797From: Les Mikesell [mailto:les@futuresource.com]
Sent: Friday, September 23, 2005 3:08 PM
To: Bruce Rudd
Cc: Mahoney, Tim; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Backing up the system

That is one option. But I would loose an customization I had and the
installation did not go without it’s problems the first time. I was
not
sure if everything resided under /opt/rt3/

You’d have to install all the needed perl modules again and fix your
httpd.conf besides having the database and things under /opt/rt3.
I like to have backuppc (http://backuppc.sourceforge.net/) running
on another machine making nightly copies of everything because it
is painless and it’s really easy to grab a few files back through
the web interface. It is also possible to get full tar images back and
thus do a full restore, although that isn’t completely automated.

Les Mikesell
les@futuresource.com

10

That is what I am looking at doing. Well, having IT do for me anyway.
I am just not sure what all the location are for all of the pieces I
need to backup.

The perl modules install into your system perl location and as
some recent messages here have shown, different versions don’t
always work so you might not be able to grab fresh copies from
CPAN. If you plan to rebuild from scratch on similar hardware,
someone should work out how to do a bare metal recovery from
the tar images. There is just some grunge work involved making
the partitions and filesystems and making it bootable after the
restore that will depend on your OS version and disk layout.
If you plan to rebuild an updated version instead you would just
need your database and your RT_SiteConfig.pm (and probably a
lot more time). Somewhere in between would be keeping copies
of all the CPAN modules and your current version of RT so you
could re-install into any reasonably similar OS.

Les Mikesell
les@futuresource.com