Hello Community !
I am looking to migrate and upgrade a self-hotsed OpenProject instance to Azure-hosted one.
I am stuck when restoring the database to the new instance.
Architecture Details
The version of source instance is 7.4.7 (VMDK)
The version of destination instance is 10.x (deploy by AzureMarketplace).
This migration involves the following porblematics :
version upgrade from 7.4.7 to 10.x
SQL engine migration from MySQL to PostgreSQL
self-hosted image to azure-hosted image
Explanations
I mainly used this documentation article :
https://docs.bitnami.com/azure/apps/openproject/administration/upgrade/
I have adapted some steps in relation to the problems mentioned above
I try two migration paths for database migration :
MySQL dump from old instance and PostgreSQL import :
Using -compatible postgresql argument with mysql dump cmd
This way returns error syntax while trying import of SQL backup
-
pgloader project :
This way returns following error :
bitnami@debian:~/backup2$ pgloader --dry-run --verbose mysql://bn_openproject:MYSQL_PASSWORD@localhost/binami_openproject pgsql://postgres:POSTGRESQL_PASSWORD@104.45.29.66/bitnami_openproject
2019-11-15T14:28:45.024000Z NOTICE Starting pgloader, log system is ready.
2019-11-15T14:28:45.038000Z LOG Main logs in '/tmp/pgloader/pgloader.log'
2019-11-15T14:28:45.041000Z LOG Data errors in '/tmp/pgloader/'
2019-11-15T14:28:45.442000Z FATAL An unhandled error condition has been signalled:
Failed to connect to mysql at "localhost" (port 3306) as user "bn_openproject": Condition QMYND-IMPL::PROTOCOL-VERSION-MISMATCH was signalled.
Is my problem known and / or documented?
Is there a workaround?
EDITED: @gongomgra removed sensitive data