vangz
March 3, 2021, 6:53am
1
I am trying to backup H2 Databases following this thread:
Backing up Metabase Avoid losing your application data (all of your questions, dashboards, collections and so on) by backing up your data. Metabase uses a single SQL database for all of its runtime application data, so all you need to do...
so it says that the file should be on the same directory of running metabase
And I have 2 PC, 1 is with Windows Platform and 1 is with Ubuntu Platform
it sure is shown in 1 directory in Ubuntu
BUT, the file doesn't show in Windows, only the jar file (i already make sure to view the hidden files)
So, How can I find the metabase.db.mv and metabase.db.trace files on Windows? thankyouu :>
Hi @vangz
It depends on how you’re starting Metabase - it would be in reference to the CWD of the command.
You should migrate away from H2 if you’re using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
vangz
March 5, 2021, 9:21am
3
thanks for the reply @flamber
actually on WIndows I only do apply these:
Download Metabase jar file from download page in: https://www.metabase.com/docs/latest/operations-guide/running-the-metabase-jar-file.html
I placed the downloaded metabase jar on above directory
Then I simply run in cmd with: java -jar "C:/Users/User/Downloads/BI Tools/Metabase/metabase.jar"
thats all what I do in Windows, and also I already make some visualization in localhost:3000, but I cant find anywhere the metabase.db.mv and metabase.db.trace…
@vangz I don’t know which directory you are in, when you run the java ...
command, but that’s the CWD (current working directory) and that will be where the H2 files will be placed.
I would highly recommend not using H2 - use Postgres or MySQL/MariaDB instead:
https://www.metabase.com/docs/latest/operations-guide/configuring-application-database.html
1 Like
vangz
March 5, 2021, 12:03pm
5
I see so the directory is the where cmd is runned, okay noted, find it already :>
vangz
March 5, 2021, 12:05pm
6
yes this is for testing only, since the production data is still not ready