How to restore database in other server

ingenieroit

I had an ostickets installation in version 1.7 on a server and I had to migrate it to another one with the latest version. What I want to know is how I can mount the same database in the new installation to be able to have the history of the tickets that I already had on the other server, or at least so that I can consult the previous database to see the old tickets created.

KevinTheJedi

ingenieroit

First turn the helpdesk offline and disable email fetching, next do a full mysql database dump of the current osTicket database (it's best to use the native mysqldump command), move that .sql file to the new server, import that .sql file into a new database on the new server, copy over your old include/ost-config.php file to the new server, and update the config file to update the connection/db information for the new server. Then you can login to osTicket as an Administrator on the new server and start the upgrade process.

You can view the Upgrade Documentation here:

https://docs.osticket.com/en/latest/Getting%20Started/Upgrade%20and%20Migration.html

Cheers.