@jornh What’s causing the exception error using the following command?
java -DMB_DB_TYPE=mysql -DMB_DB_DBNAME=metabase -DMB_DB_PORT=3306 -DMB_DB_USER=xxxxxxx@gmail.com -DMB_DB_PASS=xxxxx -DMB_DB_HOST=localhost -jar metabase.jar load-from-h2 C:\xampplite\mysql\data\metabase\db.opt
org.h2.jdbc.JdbcSQLException: Database “C:/xampplite/mysql/data/metabase/db.opt” not found [90013-194]
Command failed with exception: Database “C:/xampplite/mysql/data/metabase/db.opt” not found [90013-194]
An empty mysql db was created to receive the h2 migration using PHPMyAdmin - MySQL Administration. The db name is metabase and it creates a folder named as such with a single db.opt file containing the db characteristics (very little):
default-character-set=latin1
default-collation=latin1_swedish_ci
As the migration proceeds the .frm and .ibd files appear but the .opt file is the only thing to point to when starting out. Omitting the path at the end of the command migrates the data but results in a static db as I soon discovered (my jubilation was very short lived).
How is the magic done of actually getting the Metabase application db based on mysql so as to log into it via http://localhost:3000/auth/login?
Metabase: 0.29.2
MySQL: 5.6.24
Databases: H2 internal default, Server SQL external (joined in)
Host: Localhost:3000
OS: Microsoft Windows [Version 6.0.6002]
Browser: Firefox 52.8.0