Migrate RT database when $rtname has changed

Hi all!

Is it possible to migrate an RT database from one machine to another
where $rtname is “MyCorpManager” on the source machine and i want it
to be “MyCorpHelpdesk” on the destination?

Could I just do an SQL dump and change all strings “MyCorpManager” to
"MyCorpHelpdesk" of it?

I know that the RT won’t process replies to old tickets, but I found a
way around for that. I just want to know if this process will blast my
destination RT instance?

Thanks in advance.

Best regards.

Pedro Machado Santa

I did that last week: I migrate RT, RTFM and RTIR from one server to
other (database and programs) and change RTname. I had problems because
I tried to update RTIR. So, I decided to stay at 1.1.2.

You only need to change RT_SiteConfig.pm:

#Set($rtname , “CC-DRC”); ← My old name
#Set($rtname , “CECOM”); ← My new name
Set($rtname , “MyCorpHelpdesk”); <— Your new name
#Set($EmailSubjectTagRegex, qr/\QCECOM\E|\QCC-DRC\E/i ); <— works
#Set($EmailSubjectTagRegex, qr/\Q$rtname\E/i ); ← Original line
#Set($EmailSubjectTagRegex, qr/(?:CECOM|CC-DRC)/i ); ← doesn’t work
Set($EmailSubjectTagRegex, qr/\QMyCorpManage\E|\QMyCorpHelpdesk\E/i );
Set($Organization , “ufmg.br”); <---- don 't change this line

Set($Timezone , ‘Brazil/East’);Em Seg 09 Abr 2007, Pedro Santa escreveu:

Hi all!

Is it possible to migrate an RT database from one machine to another
where $rtname is “MyCorpManager” on the source machine and i want it
to be “MyCorpHelpdesk” on the destination?

Could I just do an SQL dump and change all strings “MyCorpManager” to
“MyCorpHelpdesk” of it?

I know that the RT won’t process replies to old tickets, but I found
a way around for that. I just want to know if this process will blast
my destination RT instance?

Thanks in advance.

Best regards.

Pedro Machado Santa


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

 Fernando Frota Machado de Morais
    Divisao de Redes de Comunicacao
    Centro de Computacao
    Universidade Federal de Minas Gerais
    Brasil
    Tel. +55(31)3499.4007  Fax. +55(31)3499.4004

/"
\ / Campanha da fita ASCII - contra mail html
X ASCII ribbon campaign - against html mail
/ \

Request Tracker Wiki 4/9/07, Fernando Frota Machado de Morais frota@cecom.ufmg.br wrote:

I did that last week: I migrate RT, RTFM and RTIR from one server to
other (database and programs) and change RTname. I had problems because
I tried to update RTIR. So, I decided to stay at 1.1.2.

You only need to change RT_SiteConfig.pm:

#Set($rtname , “CC-DRC”); ← My old name
#Set($rtname , “CECOM”); ← My new name
Set($rtname , “MyCorpHelpdesk”); <— Your new name
#Set($EmailSubjectTagRegex, qr/\QCECOM\E|\QCC-DRC\E/i ); <— works
#Set($EmailSubjectTagRegex, qr/\Q$rtname\E/i ); ← Original line
#Set($EmailSubjectTagRegex, qr/(?:CECOM|CC-DRC)/i ); ← doesn’t work
Set($EmailSubjectTagRegex, qr/\QMyCorpManage\E|\QMyCorpHelpdesk\E/i );
Set($Organization , “ufmg.br”); <---- don 't change this line

Set($Timezone , ‘Brazil/East’);

Em Seg 09 Abr 2007, Pedro Santa escreveu:

Hi all!

Is it possible to migrate an RT database from one machine to another
where $rtname is “MyCorpManager” on the source machine and i want it
to be “MyCorpHelpdesk” on the destination?

Could I just do an SQL dump and change all strings “MyCorpManager” to
“MyCorpHelpdesk” of it?

I know that the RT won’t process replies to old tickets, but I found
a way around for that. I just want to know if this process will blast
my destination RT instance?

Thanks in advance.

Best regards.

Pedro Machado Santa


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Fernando Frota Machado de Morais
Divisao de Redes de Comunicacao
Centro de Computacao
Universidade Federal de Minas Gerais
Brasil
Tel. +55(31)3499.4007 Fax. +55(31)3499.4004

/"
\ / Campanha da fita ASCII - contra mail html
X ASCII ribbon campaign - against html mail
/ \


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.