Thanks @jornh, I appreciate the input. MySQL 5.6.24 for the moment, the stumbling block is I’m obviously misunderstanding how to go about this. I’m in the command prompt (as admin) trying one command at a time like so:
c:\Program Files\Metabase>export MB_DB_TYPE=mysql
‘export’ is not recognized as an internal or external command,
operable program or batch file.
Alternatively like so:
c:\Program Files\Metabase>MB_DB_TYPE=mysql
‘MB_DB_TYPE’ is not recognized as an internal or external command,
operable program or batch file.
And the rather dated post cited does end talking about environment variables in Windows being an issue… Looked up Environment Variables and that’s even more confusing…
Honestly, I haven’t a clue at this point, not even the slightest!..
+++++++++++++
Just saw the edit at the end of your response on refresh… So invoke java -d then whatever command…
c:\Program Files\Metabase>java -d MB_DB_TYPE=mysql
Unrecognized option: -d
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.
c:\Program Files\Metabase>java -dMB_DB_TYPE=mysql
Unrecognized option: -dMB_DB_TYPE=mysql
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.
Nope, I’m still messing something up…
+++++++++++++
Ah Ha! Case sensitive and doesn’t like spaces… Touchy ain’t it! Ignoring all the clutter that pops up after every step for the time being, it appears to have at least tried to do something but failed…
c:\Program Files\Metabase>java -DMB_DB_TYPE=mysql
c:\Program Files\Metabase>java -DMB_DB_DBNAME=metabase
c:\Program Files\Metabase>java -DMB_DB_PORT=3306
c:\Program Files\Metabase>java -DMB_DB_USER=xxxxxxxxxxxxxxx@xxxxx.com
c:\Program Files\Metabase>java -DMB_DB_PASS=xxxxxxxxxx
c:\Program Files\Metabase>java -DMB_DB_HOST=localhost
c:\Program Files\Metabase>java -jar metabase.jar load-from-h2
05-21 21:26:36 ←[1mINFO metabase.util←[0m :: Loading Metabase…
05-21 21:26:50 ←[1mINFO util.encryption←[0m :: DB details encryption is DISABLED
for this Metabase instance.
See http://www.metabase.com/docs/latest/operations-guide/start.html#encrypting-y
our-database-connection-details-at-rest for more information.
java.io.FileNotFoundException: C:\Program%20Files\Metabase\metabase.jar (The sys
tem cannot find the path specified)
05-21 21:27:40 ←[1mINFO metabase.db←[0m :: Verifying h2 Database Connection …
05-21 21:27:42 ←[1mINFO metabase.db←[0m :: Verify Database Connection …
05-21 21:27:42 ←[1mINFO metabase.db←[0m :: Running Database Migrations…
05-21 21:27:42 ←[1mINFO metabase.db←[0m :: Setting up Liquibase…
05-21 21:27:42 ←[1mINFO metabase.db←[0m :: Liquibase is ready.
05-21 21:27:42 ←[1mINFO metabase.db←[0m :: Checking if Database has unrun migrat
ions…
05-21 21:27:56 ←[1mINFO metabase.db←[0m :: Database Migrations Current …
com.mchange.v2.cfg.DelayedLogItem [ level -> FINE, text -> “The configuration fi
le for resource identifier ‘hocon:/reference,/application,/c3p0,/’ could not be
found. Skipping.”, exception -> null]
Temporarily disabling DB constraints…
java.lang.IllegalArgumentException: No matching clause: :h2
at metabase.cmd.load_from_h2$disable_db_constraints_BANG_.invokeStatic(l
oad_from_h2.clj:179)
at metabase.cmd.load_from_h2$disable_db_constraints_BANG_.invoke(load_fr
om_h2.clj:177)
at metabase.cmd.load_from_h2$load_from_h2_BANG_$fn__36792.invoke(load_fr
om_h2.clj:224)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:741)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:711)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:776)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:711)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:724)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:711)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h
2.clj:222)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:
215)
at clojure.lang.Var.invoke(Var.java:379)
at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:36)
at metabase.cmd$load_from_h2.invoke(cmd.clj:29)
at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:32)
at metabase.cmd$load_from_h2.invoke(cmd.clj:29)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:646)
at clojure.core$apply.invoke(core.clj:641)
at metabase.cmd$run_cmd$fn__38500.invoke(cmd.clj:132)
at metabase.cmd$run_cmd.invokeStatic(cmd.clj:132)
at metabase.cmd$run_cmd.invoke(cmd.clj:128)
at clojure.lang.Var.invoke(Var.java:383)
at metabase.core$run_cmd.invokeStatic(core.clj:269)
at metabase.core$run_cmd.invoke(core.clj:267)
at metabase.core$_main.invokeStatic(core.clj:278)
at metabase.core$_main.doInvoke(core.clj:274)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.core.main(Unknown Source)
Command failed with exception: No matching clause: :h2
Now I really am stuck!