What needs to be backed up?

I have not found any documentation on what files should be backed up:

  • For a routine backup of the database.
  • Before upgrading to a new version of RT or tinkering with the setup.

Any suggestions would be most welcome.

Dag Bruck
Dynasim, Sweden

“DB” == Dag Bruck dag@dynasim.se writes:

DB> I have not found any documentation on what files should be backed up:
DB> - For a routine backup of the database.

that’s easy. just use your DB server’s dump utility to get a
consistent backup. postgres does this with pg_dump.

you should also back up any file you edited during installation,
usually just the RT site config file.

DB> - Before upgrading to a new version of RT or tinkering with the setup.

same as routine backup, i should think, as long as you have the
original source for the RT version you’re upgrading/tinkering.

For my RT2, I backup the following and burned to CD:

/usr/local/apache/conf/httpd.conf
/etc/mail/
/etc/hosts
/etc/aliases
/usr/lib/perl5/
/opt/rt2/
rt-2-0-15 (the build directory)
/var/log/rt/

I use mysql, so I do a dump every night with:

/usr/bin/mysqldump --opt rt2 > rt2.sql
and push it to a safe host.

If/when my machine dies and I need to restore, I build
a new RH8 system, and restore the backed up files to a
tmp directory. Start mysql, go to the rt2-build
directory, and do ‘make install’
If the rt2 db already exists, you’ll get an error.
So, do ‘make dropdb’, ‘make install’.

Drop the backed up files over the top of your existing
RH8 install.
If the new IP is different, change IP in
/opt/rt2/etc/config.pm

Get the lastest mysql dump, and load it:

mysql rt2 < rt2.sql

cd /etc/smrsh

ln -s /opt/rt2/bin/rt-mailgate .

newaliases

I think that is everything. :)— Dag Bruck dag@dynasim.se wrote:

I have not found any documentation on what files
should be backed up:

  • For a routine backup of the database.
  • Before upgrading to a new version of RT or
    tinkering with the setup.

Any suggestions would be most welcome.

Dag Bruck
Dynasim, Sweden


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

“I’m the Commander, see … I do not need to explain why I say things. That’s the interesting thing about being the President … [I] don’t feel like I owe anybody an explanation.” – President George W. Bush to the National Security Council

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com