How to upgrade a db on a remote box

RT Users
1

How does one migrate a database as in the README file if the database is
on a separate server? Would I actually have to install RT on the
database box? I am not doing this, but I was curious and didn’t see the
answer in the README or a google search.

Vicki

2

If you’re migrating from the same version of RT and MySQL, I would think
you could just do a mysqldump then import it into an empty database on
the new box.

Don
dsalensky@servervault.com-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Vicki
Stanfield
Sent: Wednesday, June 01, 2005 15:43 PM
To: ‘RT users’
Subject: [rt-users] How to upgrade a db on a remote box.

How does one migrate a database as in the README file if the database is
on a separate server? Would I actually have to install RT on the
database box? I am not doing this, but I was curious and didn’t see the
answer in the README or a google search.

Vicki

3

Salensky, Don wrote:

If you’re migrating from the same version of RT and MySQL, I would think
you could just do a mysqldump then import it into an empty database on
the new box.

Don
dsalensky@servervault.com

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Vicki
Stanfield
Sent: Wednesday, June 01, 2005 15:43 PM
To: ‘RT users’
Subject: [rt-users] How to upgrade a db on a remote box.

How does one migrate a database as in the README file if the database is
on a separate server? Would I actually have to install RT on the
database box? I am not doing this, but I was curious and didn’t see the
answer in the README or a google search.

Vicki

The rt-users Archives

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

Unfortunately, I was going from 3.0.0 to 3.4.1. The migration was
definitely required. As I was going through the steps, however, I began
to wonder what would happen if the database was on another machine. I
didn’t see an option for specifying a different database name nor a
different server unless they are being taken from the RT_SiteConfig.pm file.

Vicki

4

Greetings!

  • Server1 is RT box
  • Server2 is MySql box
  1. Upgrading RT on Server1.
  2. Editing RT_SiteConfig ( $DatabaseHost, $DatabasePassword, etc)
  3. Running /opt/rt3/sbin/rt-setup-database -action …
    -datadir $path_to_src/etc/upgrade/…

I think this should work.

SY, Danial.

Danial Klimkin,
Falk eSolutions AG Russia

Vicki Stanfield wrote:

5

Danial Klimkin wrote:

Greetings!

  • Server1 is RT box
  • Server2 is MySql box
  1. Upgrading RT on Server1.
  2. Editing RT_SiteConfig ( $DatabaseHost, $DatabasePassword, etc)
  3. Running /opt/rt3/sbin/rt-setup-database -action …
    -datadir $path_to_src/etc/upgrade/…

I think this should work.

SY, Danial.

So, you are saying that the migration scripts do use the settings in
RT_SiteConfig.pm then. Okay, that was the only way I could see that it
could work. Thanks.

Vicki