This is my command for migrating h2 to mysql, but I got a error
docker run --name m3 -v /data/metabase.db:/metabase.db -p 3000:3000 -e "MB_DB_TYPE=mysql" -e "MB_DB_DBNAME=metabase" -e "MB_DB_USER=my_user_name" -e "MB_DB_PASS=my_password" -e "MB_DB_HOST=mysql_host" metabase/metabase:latest load-from-h2
I put old database file in the host path: /data/metabase.db
But I got a error:
Command failed with exception: ERROR Set up h2 source database and run migrations...
Hi @lee
You are not referencing the H2 file.
You could include it with the variable MB_DB_FILE=/metabase.db/metabase.db
I change the command to
docker run --name m3 -v /data/metabase.db:/metabase.db -p 3000:3000 -e "MB_DB_FILE=/metabase.db/metabase.db" -e "MB_DB_TYPE=mysql" -e "MB_DB_DBNAME=metabase" -e "MB_DB_USER=my_user_name" -e "MB_DB_PASS=my_password" -e "MB_DB_HOST=mysql_host" metabase/metabase:latest load-from-h2
The error exists yet:
Metabase Enterprise Edition extensions are NOT PRESENT.
2021-08-12 01:08:13,782 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2021-08-12 01:08:13,839 INFO cmd.copy :: Set up h2 source database and run migrations...
2021-08-12 01:08:13,842 INFO db.setup :: Verifying h2 Database Connection ...
2021-08-12 01:08:13,952 ERROR cmd.copy :: [FAIL]
Command failed with exception: ERROR Set up h2 source database and run migrations...
@lee I have no idea the structure of your files. I would recommend that you do the migration via JAR instead of Docker. It's a one-off process.
@flamber JAR really save a lot of time. There are many tricks via docker. Thank you very much!