I have a MySQL DB dump of an RT instance that I used many years ago.
I am thinking it was rt-4.x then, but I don’t remember well.
Does RT store anything to do with it’s version in the DB?
I’d like a way to figure out what RT version it was and then upgrade it all the way to 5.0.7 without skipping any version, which might lead to more problems.
I’m not sure if there’s a version number stored as a specific field, at least I can’t find one in a casual search, but you might be able to infer it from the attachments.
Emails, by default, include an X-Managed-BY: header that contains the version, e.g. X-Managed-BY: RT 4.4.2
and the email message id is prefixed with the RT version number, e.g. Message-ID: rt-4.4.2-31819-[..]
In version 3.x it looks like that was just Managed-BY and was updated some time later to be standards compliant.
Hopefully someone who understands the schema better than me will weigh in with a better way if there is one.
Good luck.
Simon.
You can pull the upgrade history out of the Attributes table where name = ‘UpgradeHistory’. But, this is a base64 encoded string from the results of Storable::nfreeze of a Perl data structure. So … possibly not so useful.