Merging RT Databases

Has anyone had success with merging two RT 1 (we’re running 1.0.7) databases
(on MySQL) and importing them into RT 2.0.11?

Thanks in advance.

-Grant Miller grant@pico.apple.com

Unix Systems Admin, Engineering Compute Services, Apple Computer

Hi!

I have made a migration of RT from version 3.0.9 to 3.6.1 with MySQL 5.0 and
it’s working very well.

The problem is that I have a second RT running on another machine that
contains data that I want to put/merge into the new RT database.

With this I’ll have one RT with one database instead two RT’s with two
databases.

Is that possible?

If so, how can I do that?

I can’t just make a mysqldump because the Ticket ID’s already exists in the
first one.!

Someone can help me with this?

Thanks a lot.

Ruben Romao

e: rubenromao@gmail.com

This sounds not possible to me, because i think both rt instances are useing
the same ticket numbers? When you try to merge them i think you get a awful
chaos!

Torsten2007/1/30, Ruben Romao rubenromao@gmail.com:

Hi!

I have made a migration of RT from version 3.0.9 to 3.6.1 with MySQL 5.0and it’s working very well.

The problem is that I have a second RT running on another machine that
contains data that I want to put/merge into the new RT database.

With this I’ll have one RT with one database instead two RT’s with two
databases.

Is that possible?

If so, how can I do that?

I can’t just make a mysqldump because the Ticket ID’s already exists in
the first one…!

Someone can help me with this?

Thanks a lot.

Ruben Romao

e: rubenromao@gmail.com


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

MFG

Torsten Brumm

http://www.torsten-brumm.de