Want Migrating from using the H2 database to MySQL

I want Migrating from using the H2 database to MySQL
export MB_DB_TYPE=mysql
export MB_DB_DBNAME=metabase
export MB_DB_PORT=3306
export MB_DB_USER=…
export MB_DB_PASS=…
export MB_DB_HOST=47.10.****
java -jar metabase.jar load-from-h2

When I perform these operations,will append the data in the default database is not migrated.!

There are these tables, but the orders, people in the default H2 database, these tables are not,

Ah OK, so you say, the migration of the Metabase application data worked as it should? Fine.

You are right it does not migrate the Sample Dataset - which is only there to demo Metabase. So, that is an enhancement request for Metabase. (To add an option flag on the migration script)

As alternative you can search the internet for tools or the manual steps that do this between H2 and MySQL already. I use DBeaver as SQL workbench, it can do it with export/import.

Ok, thank you for your answer, let me study what you said about the steps between H2 and MySQL. Thank you very much.

1 Like