The company I am working for uses RT 4.2.3 since 2014 on CentOS. We are looking to upgrade RT on ad different operating system (Possibly Ubuntu 20.04/22.04) without losing any tickets.
What would be the best way to approach this migration, please?
Should we migrate RT 4.2.3 to the new OS and then upgrade it to RT 5.x, or is it possible to directly export the database and the configuration of RT 4.2.3 to the new RT 5.x?
Hi, thanks for that. Have you run any commands after
pv rt4.sql | mysql -u root -p rt5
to update the schema from 4.4.4 to 5.0.0? Or is it done with that command as well?
I am trying to import an RT 4.2.3 database to a 5.0.1 installation but after I use the command you provided I am able to log in but as soon as I open any ticket the server crashes.
After a clean installation of RT5 I dropped all tables of the rt5 database. I did not delete the database. After that, I imported the rt 4.4.4 database and then run the command “make upgrade-database”. Follow the script instructions and you should be good to go. As I understand, you imported over the existing database.
Just to be sure I am doing it correctly, in which folder are you running the command “make upgrade-database”, please?
No, I don’t need to import it over an existing database it can also be on a clean database.
We have currently a VM with RT 4.2.3 running on CentOS 6 and we are trying to migrate the RT to Ubuntu 22.04 with RT 5.0.x, so first I installed RT and now I am trying to move the database across.
You run the “make upgrade-database” in the directory where you ran the “make install” command to install RT5. Essentially the folder that was extracted from the downloaded archive (i.e. rt-5.0.2.tar.gz). If you import your database dump on a new database, the database name will be rt4, take that into consideration as it is required to be specified in the configuration files of your RT installation.
Also, please make sure you read the manual carefully on section 6b.