JAR based migration from H2 to MySQL "ERROR Set up mysql target database and run migrations"

Get Help
1

I have followed a couple of threads with similar issues but haven't found anything that has been helpful thus far. Hoping someone can see where I am messing up and point me in a better direction.

Reference URLs:

Current 0.41.2 jar based install has been running great for the past couple of years but now I would like to migrate from H2 to MySQL and then (after running under MySQL for a few days) upgrade Metabase version to 0.46.5.

Base OS: Windows Server 2016

Installed MySQL Community Server 8.0.33
Verified that I can connect to MySQL and then created new empty schema named metabase

From within my metabase directory (E:\MetaBase) I'm trying the below command:

java -DMB_DB_TYPE=mysql -DMB_DB_CONNECTION_URI="jdbc:mysql://myCoolServerName:3306/metabase?user=root&password=myCoolPassword" -jar metabase.jar load-from-h2 metabase.db

The log from the attempt is below. Any assistance is appreciated.

# java -DMB_DB_TYPE=mysql -DMB_DB_CONNECTION_URI="jdbc:mysql://CLP1-WJENUT01:3306/metabase?user=root&password=zaq1@WSX" -jar metabase.jar load-from-h2 metabase.db
Warning: environ value E:\Java\jdk1.8.0_251 for key :java-home has been overwritten with E:\Java\jre1.8.0_251
2023-06-16 18:02:31,036 INFO metabase.util :: Maximum memory available to JVM: 1.8 GB
2023-06-16 18:02:42,036 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
 For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2023-06-16 18:02:44,739 INFO driver.impl :: Registered abstract driver :sql
 ? Load driver :sql took 606.6 ms
2023-06-16 18:02:44,754 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
Load driver :sql-jdbc took 623.1 ms
2023-06-16 18:02:44,754 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
2023-06-16 18:02:44,770 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2023-06-16 18:02:45,676 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
2023-06-16 18:02:47,967 INFO metabase.core ::
Metabase v0.41.2 (ad599fd release-x.41.x)

Copyright ⌐ 2023 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.
2023-06-16 18:02:47,980 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2023-06-16 18:02:48,029 INFO cmd.copy :: Set up h2 source database and run migrations...
2023-06-16 18:02:48,033 INFO db.setup :: Verifying h2 Database Connection ...
2023-06-16 18:02:48,318 INFO db.setup :: Successfully verified H2 1.4.197 (2018-03-18) application database connection.
2023-06-16 18:02:48,320 INFO db.setup :: Running Database Migrations...
2023-06-16 18:02:48,322 INFO db.setup :: Setting up Liquibase...
2023-06-16 18:02:48,358 INFO db.setup :: Liquibase is ready.
2023-06-16 18:02:48,360 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-06-16 18:02:49,417 INFO db.setup :: Database Migrations Current ...
2023-06-16 18:02:49,418 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2023-06-16 18:02:49,430 INFO db.data-migrations :: Finished running data migrations.
Database setup took 1.4 s
2023-06-16 18:02:49,432 INFO cmd.copy :: [OK]
2023-06-16 18:02:49,433 INFO cmd.copy :: Set up mysql target database and run migrations...
2023-06-16 18:02:49,434 INFO db.setup :: Verifying mysql Database Connection ...
2023-06-16 18:02:49,487 ERROR cmd.copy :: [FAIL]

clojure.lang.ExceptionInfo: ERROR Set up mysql target database and run migrations... {}
        at metabase.cmd.copy$do_step$fn__81984.invoke(copy.clj:33)
        at metabase.cmd.copy$do_step.invokeStatic(copy.clj:29)
        at metabase.cmd.copy$do_step.invoke(copy.clj:27)
        at metabase.cmd.copy$fn__82145$copy_BANG___82150$fn__82151.invoke(copy.clj:269)
        at metabase.cmd.copy$fn__82145$copy_BANG___82150.invoke(copy.clj:257)
        at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h2.clj:35)
        at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:25)
        at clojure.lang.Var.invoke(Var.java:384)
        at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:45)
        at metabase.cmd$load_from_h2.invoke(cmd.clj:39)
        at clojure.lang.AFn.applyToHelper(AFn.java:154)
        at clojure.lang.AFn.applyTo(AFn.java:144)
        at clojure.core$apply.invokeStatic(core.clj:667)
        at clojure.core$apply.invoke(core.clj:662)
        at metabase.cmd$run_cmd$fn__82928.invoke(cmd.clj:190)
        at metabase.cmd$run_cmd.invokeStatic(cmd.clj:190)
        at metabase.cmd$run_cmd.invoke(cmd.clj:186)
        at clojure.lang.Var.invoke(Var.java:388)
        at metabase.core$run_cmd.invokeStatic(core.clj:145)
        at metabase.core$run_cmd.invoke(core.clj:143)
        at metabase.core$_main.invokeStatic(core.clj:167)
        at metabase.core$_main.doInvoke(core.clj:162)
        at clojure.lang.RestFn.applyTo(RestFn.java:137)
        at metabase.core.main(Unknown Source)
Caused by: clojure.lang.ExceptionInfo: Unable to connect to Metabase mysql DB. {}
        at metabase.db.setup$fn__33729$verify_db_connection__33734$fn__33735$fn__33736.invoke(setup.clj:102)
        at metabase.db.setup$fn__33729$verify_db_connection__33734$fn__33735.invoke(setup.clj:100)
        at metabase.db.setup$fn__33729$verify_db_connection__33734.invoke(setup.clj:94)
        at metabase.db.setup$setup_db_BANG_$fn__33764$fn__33765.invoke(setup.clj:142)
        at metabase.util$do_with_us_locale.invokeStatic(util.clj:694)
        at metabase.util$do_with_us_locale.invoke(util.clj:680)
        at metabase.db.setup$setup_db_BANG_$fn__33764.invoke(setup.clj:141)
        at metabase.db.setup$setup_db_BANG_.invokeStatic(setup.clj:140)
        at metabase.db.setup$setup_db_BANG_.invoke(setup.clj:136)
        at metabase.cmd.copy$fn__82145$copy_BANG___82150$fn__82151$fn__82154.invoke(copy.clj:271)
        at metabase.cmd.copy$do_step$fn__81984.invoke(copy.clj:30)
        ... 23 more
Caused by: java.sql.SQLTransientConnectionException: Could not connect to address=(host=CLP1-WJENUT01)(port=3306)(type=master) : RSA public key is not available client side (option serverRsaPublicKeyFile)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1372)
        at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
        at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
        at org.mariadb.jdbc.Driver.connect(Driver.java:89)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
        at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
        at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
        at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
        at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1111)
        at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
        at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
        at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
        at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
        at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
        at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invokeStatic(connection.clj:245)
        at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:242)
        at metabase.db.setup$fn__33729$verify_db_connection__33734$fn__33735$fn__33736.invoke(setup.clj:100)
        ... 33 more
Caused by: java.sql.SQLException: RSA public key is not available client side (option serverRsaPublicKeyFile)
        at org.mariadb.jdbc.internal.com.send.authentication.Sha256PasswordPlugin.process(Sha256PasswordPlugin.java:231)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:745)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:546)
        at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1367)
        ... 51 more
Command failed with exception: ERROR Set up mysql target database and run migrations...
2