Database migration

MikeR

Hi to All,

We installed the new version osTicket v. 1.14.6 on the windows server. Is it possible to move the database from osTicket v. 1.7.0 to a new server?

Thank you

Mike

dgibson123

Hello,

The previous tech had osTicket 1.9 installed on a Windows machine. I prefer Linux so I installed osTicket 1.15.2 on CentOS 8 and then I imported the data from osTicket 1.9 to 1.15.2. After the import I went to the osTicket home page and upgraded. It was quick and easy to do so I would think you would be able to do the same.

Denise

MikeR

Hi Denise,

Thank you for your reply. I did almost the same. I installed osTicket v. 1.14.6 on a new server and restore a database from the backup. But the system doesn't show any old tickets. What do you mean "I went to the osTicket home page and upgraded"? Is it a special script to upgrade the database?

Mike

dgibson123

Sorry Mike for the vague explanation. After I logged into osTicket I was automatically presented with a page to run osTicket Upgrader. The upgrader applied the database patches needed (27 to be exact) All the data was available to me after the upgrade. I have since been configuring version 1.15.2 to create tickets from emails, creating new departments, adding filters etc. All old tickets, agents and users were present. I'm just glad that I didn't have to create from scratch.

Hope this helps.

Denise

MikeR

Thank you, Denise.