MySQL Import Question

We have two RT systems running. One is OLD old. Version 2.something I
think as I’ve not actually seen it. It seems more like a local legend
than anything but apparently it actually exists here. The other is v3.0.9.

I’ve put in place v3.6.0pre1 and have successfully run tests to port the
data over from our current Postgres database to the new MySQL database.
What I would like to do though is merge the old database into the new
one so that all the OLD old data is kept with the NEW old data.

If I import the OLD old data can I import the NEW old data next to it or
will it overwrite the OLD old data? If I can do this, how do I go about it?

Mathew Snyder
Systems Administrator
Network+
ServerVault TechOps

If I import the OLD old data can I import the NEW old data next to it or
will it overwrite the OLD old data? If I can do this, how do I go about it?

No. The tickets (and other objects) are assigned ID numbers in the
database. These numbers start at 1 (or sometimes zero) and increment up
as new objects are added. So, aside from the differences in the database
schema between versions, in both you OLD old system and your NEW old
system, you’ve got objects with IDs of 1,2,3,etc. and if you try to
merge the systems, you’ll have numerous conflicts. That being said, it
can be done, it would just take quite a bit of manual intervention.

Good luck.

Joshua Colson jcolson@voidgate.org