[rt-users] Migrate RT database when $rtname has changed

Fernando Frota Machado de Morais frota at cecom.ufmg.br
Mon Apr 9 07:45:52 EDT 2007

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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at 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
        Tel. +55(31)3499.4007  Fax. +55(31)3499.4004

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

More information about the rt-users mailing list