Migrating from h2 to mysql failed

I want to metabase default database to mysql, my version is v1.33.3
I got these error when I execute migrating command

Blockquote
[root@gp208 metabase]# java -jar metabase.jar load-from-h2 /opt/metabase/metabase.db.trace.db
11-01 11:17:06 DEBUG plugins.classloader :: Using NEWLY CREATED classloader as shared context classloader: clojure.lang.DynamicClassLoader@29d334c
11-01 11:17:06 DEBUG plugins.classloader :: Setting current thread context classloader to shared classloader clojure.lang.DynamicClassLoader@29d334c…
11-01 11:17:06 INFO metabase.util :: Loading Metabase…
11-01 11:17:06 INFO metabase.util :: Maximum memory available to JVM: 3.4 GB
11-01 11:17:09 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
11-01 11:17:10 INFO metabase.driver :: Registered abstract driver :sql 
11-01 11:17:12 INFO metabase.db :: Verifying mysql Database Connection …
11-01 11:17:12 INFO metabase.driver :: Registered abstract driver :sql-jdbc (parents: [:sql]) 
Load driver :sql-jdbc took 11.3 ms
11-01 11:17:12 INFO metabase.driver :: Registered driver :mysql (parents: [:sql-jdbc]) 
Load driver :mysql took 44.3 ms
11-01 11:17:12 INFO metabase.driver :: Initializing driver :sql…
11-01 11:17:12 INFO metabase.driver :: Initializing driver :sql-jdbc…
11-01 11:17:12 INFO metabase.driver :: Initializing driver :mysql…
11-01 11:17:13 INFO metabase.db :: Verify Database Connection … :white_check_mark:
11-01 11:17:13 INFO metabase.db :: Running Database Migrations…
11-01 11:17:13 INFO metabase.db :: Setting up Liquibase…
11-01 11:17:13 INFO metabase.db :: Liquibase is ready.
11-01 11:17:13 INFO metabase.db :: Checking if Database has unrun migrations…
11-01 11:17:14 INFO metabase.db :: Database Migrations Current … :white_check_mark:
Database setup took 1.7 s
Temporarily disabling DB constraints…
[OK]
org.h2.jdbc.JdbcSQLException: Database “/opt/metabase/metabase.db.trace.db” not found [90013-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.engine.Engine.openSession(Engine.java:64)
at org.h2.engine.Engine.openSession(Engine.java:179)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:157)
at org.h2.engine.Engine.createSession(Engine.java:140)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:351)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:124)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:103)
at org.h2.Driver.connect(Driver.java:69)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
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 metabase.cmd.load_from_h2$load_data_BANG_.invokeStatic(load_from_h2.clj:161)
at metabase.cmd.load_from_h2$load_data_BANG_.invoke(load_from_h2.clj:160)
at metabase.cmd.load_from_h2$load_from_h2_BANG_$fn__67421.invoke(load_from_h2.clj:249)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:799)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:769)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:834)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:769)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:782)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:769)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h2.clj:242)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:231)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:41)
at metabase.cmd$load_from_h2.invoke(cmd.clj:34)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:665)
at clojure.core$apply.invoke(core.clj:660)
at metabase.cmd$run_cmd$fn__66653.invoke(cmd.clj:156)
at metabase.cmd$run_cmd.invokeStatic(cmd.clj:156)
at metabase.cmd$run_cmd.invoke(cmd.clj:152)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.core$run_cmd.invokeStatic(core.clj:133)
at metabase.core$run_cmd.invoke(core.clj:131)
at metabase.core$_main.invokeStatic(core.clj:142)
at metabase.core$_main.doInvoke(core.clj:138)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.core.main(Unknown Source)
Command failed with exception: Database “/opt/metabase/metabase.db.trace.db” not found [90013-197]

The file in metabase catalog just this

Blockquote
[root@gp208 metabase]# ll
total 2881008
-rw-r–r--. 1 root root 179505388 Aug 2 16:17 jdk-8u221-linux-x64.rpm
-rw-r–r--. 1 root root 8904704 Nov 1 11:36 metabase.db.mv.db
-rw-r–r--. 1 root root 2572876113 Nov 1 10:35 metabase.db.trace.db
-rw-r–r--. 1 root root 188797231 Oct 8 15:55 metabase.jar
-rw-r–r--. 1 root root 186 Nov 1 10:39 metabase.sh
drwxr-xr-x. 2 root root 4096 Oct 8 17:19 plugins
-rw-r–r--. 1 root root 46292 Nov 1 11:05 web.log

Is there any help for me?

No one has this problem?

I’m also having troubles migrating from h2 to mysql, but I’m running stuck on a different point then you (making a database connection). It’s quite frustrating.

Not sure if we can expect help from the developers here…

Yes, I have had. I found it helpful to list the commands I’d used. Then people were able to tell me where I’d gone wrong.

Hey, @aliks. If you’re using the enterprise version of Metabase (as it seems you are from the version you mentioned), you can reach out to the support email address for help with your problem.

I have fixed this trouble.

Just execute 'java -jar metabase.jar load-from-h2 /opt/metabase/metabase.db ’ , even there is no files named metabase.db。

I suggest try your mysql connect on mysql server with ‘mysql -uuser -ppass -hip -P3306’, make sure your connect info is ok.

I have fixed this trouble.

Just execute 'java -jar metabase.jar load-from-h2 /opt/metabase/metabase.db ’ , even there is no files named metabase.db。

I had list my commands and results in the topic, It may not be so obvious!