Hello,
I have:
OSTicket 1.9, PHP 5.3.14, MySQL 5.5, PHP Manager 1.2 for IIS7 running on Windows Server 2008R2.
I want to install on Windows Server 2016:
OSTicket 1.10, PHP 5.6.40, MariaDB 10.2.13 and phpmanager for IIS 10 V1.5

and then (copy/move) the database from the old server to the new server.

I think the MySQL to MariaDB move will be a big issue. Comments?

Honestly it shouldn't be an issue. I've gone from Windows MySQL to Linux MariaDB and from Windows MySQL to Window MariaDB just to play with osTicket in a different environment before. I never encountered any issues migrating the database.

Use your favorite method of taking a dump of the database. (I personally use command line mysqldump on linux or MySQL workbench on Windows). Copy the file over to the new server and restore it. Create a new user (and give it either the same username/password or a new one) . Grant it privs to the new database you created (by restoring).

Doing an upgrade at the same time makes it a little easier because you only have to copy your /include/ost-config.php file from the old server to the new one [note if you used a new username/password for the db user you do have to update the file]. And put the new (1.10 for you) source in the web folder. I will say that I have not used IIS 10 yet.

Write a Reply...