I thought I just managed to migrate to MySQL. I lost the terminal output from ājava -jar metabase.jar load-from-h2 /opt/metabase/metabase.dbā but it ended without an error condition and I see the table I specified populated with both tables and data but it seems Iām still using H2. I tried following all the steps in the migration page but did I miss something?
I also have Metabase already setup as a service. (I had to remind myself of that when it would re-spawn every time I would kill the process and it would automatically restart.)
Looking at the Debian page you linked to, do I need the MB_DB_TYPE environment variable? Iām also confused by āpost the command youāre using to start Metabaseā - in every place I see, itās just java -jar /path/to/metabase.jar.
@Greg Correct, you need to define MB_DB_TYPE=mysql in your service script, otherwise it doesnāt know that it should be using MySQL instead of H2.
If you have setup a SystemD service with EnvironmentFile, then those envvars are parsed down the ExecStart, so that should be enough.
I guess the problem was that you just didnāt have MB_DB_TYPE defined.
Got it. I actually had put the environment variables in my own userās profile instead of the /etc/default/metabase file. Fixed that, rebooted and weāre on MySQL!