Migrating H2 to MySQL

Get Help
1

Hi I have my metabase.db.mv.db file located at /root/test-docker/metabase.db/metabase.db.mv.db and I am running the following command to migrate to MySQL .
docker run --name metabase-migration -v /root/test-docker/metabase.db:/root/test-docker/metabase.db -e “MB_DB_FILE=/root/test-docker/metabase.db/metabase.db” -e “MB_DB_TYPE=mysql” -e “MB_DB_DBNAME=metabase” -e “MB_DB_PORT=3306” -e “MB_DB_USER=myusers” -e “MB_DB_PASS=mypass” -e “MB_DB_HOST=myhost” metabase/metabase load-from-h2

But I get an error saying that
"the database does not exist on Command failed with exception: Database “/root/test-docker/metabase.db/metabase.db/metabase.db” not found [90013-197] "

Please help with this I have tried different combinations of path but it seems to be adding metabase.db at the end of my path

I have also tried with command

docker run --name metabase-migration -v /root/test-docker/metabase.db:/root/test-docker/metabase.db -e “MB_DB_FILE=/root/test-docker/metabase.db/” -e “MB_DB_TYPE=mysql” -e “MB_DB_DBNAME=metabase” -e “MB_DB_PORT=3306” -e “MB_DB_USER=myusers” -e “MB_DB_PASS=mypass” -e “MB_DB_HOST=myhost” metabase/metabase load-from-h2

In that case it gives me
Command failed with exception: Database “/root/test-docker/metabase.db/metabase.db” not found [90013-197]

2

Hi @babarali
What was your command, when you were running on H2 in the same container?

3

docker run -d -p 3000:3000 --name metabase metabase/metabase

4

@babarali Okay, but then your H2 is located in the default location, which is /metabase.db - so I’m not sure why you’re doing the volume mounting now, when you didn’t do it before…?
I’m fairly sure you’re having problems with file/directory permissions. Make sure that you can start Metabase on H2 before trying to migrate.