Load-from-h2 not seeing database


#1

I’ve got a metabase container (based on metabase/metabase:v0.31.2).

I’m running: java -jar metabase.jar load-from-h2

I have a h2 database in /app/metabase.db/.

When I run the load-from-h2 command I get this error:

Command failed with exception: Database "/app/metabase.db" not found [90013-197]

What am I doing wrong?


#2

Hi @krainboltgreene
Where’s the actual H2 file located? Because you’re ending with a / in /app/metabase.db/, which makes me think it’s a directory and the database file is located inside.
If you actual file is located here: /app/metabase.db/my-mb.db.mv.db then you would start with:

docker run -d -p 3000:3000 -v /app/metabase.db:/app/metabase.db -e "MB_DB_FILE=/app/metabase.db/my-mb.db" --name metabase metabase/metabase

https://www.metabase.com/docs/latest/operations-guide/running-metabase-on-docker.html
But may I recommend that you use Postgres or MySQL as your backend, since H2 can easily become corrupted.
https://www.metabase.com/docs/latest/operations-guide/start.html#migrating-from-using-the-h2-database-to-mysql-or-postgres


#3

Ahhhh, that’s a lot more clear. Yes I’m actually doing this to switch to postgresql.