Hey there,
I just tested the new version of Zammad on a new server. So far everything is working fine. I installed PostgreSQL as the new database, since it was advised in the documentation. We also have a live server with different settings. We used MySQL on the old one because of another software running on the server. Another difference is, that the new server is running Ubuntu 18.04 instead of the previous 16.04 like the old server. Also the Zammad version does not match anymore.
Has someone experience with such a migration? Is it even possible to migrate the old environment to the new server without problems? And if so, could someone help me out?
I guess the steps in the thread posted above still apply, but I have to convert the MySQL dump to a PostgreSQL as an additional step.
I’m afraid, migration between both database systems won’t be covered and possible without conversion.
We do not provide any conversion scripts, as this needs manual validations and hands on.
(We do provide conversion services if needed, but that might get a bit expensive, you might want to stick with MySQL in your case)
The Zammad-Version on the destination system has to be the same Zammad version or higher.
The guide from hannes will fully apply - you just can’t use it on different database server types. (so your DB type has to match on both systems, version doesn’t matter too much)
A quick update for everyone.
I couldn’t workout a good way to convert the databases without problems. Therefore I installed MySQL on the new server, configured Zammad to use MySQL instead of postgreSQL, uninstalled postgreSQL and imported the MySQL dump from the old one. I still had some problems with elasticsearch but a quick research helped me identify the problem. I had to rebuild the search index ( zammad run rake searchindex:rebuild). So far it works great