I recently created a metabase and succefully connected it to my MySQL database and its working fine, running locally. ( Windows)
But everytime I have to turn off my computer, I have to add again the database to metabase and lose all the work done. When I reconnect, the database is there but I can’t see any data. Just keeps" Loading" and gives an error message in summary graphs. I have to delete, relaunch the java app and add the database again in order to work.
I believe that maybe I skipped some steps? Can you help?
Sorry, I’m not very proficient in MYSQL and connections. I could figure it out where to run the fisrt part of the script " export MB_DB_TYPE=mysql
export MB_DB_DBNAME=metabase
export MB_DB_PORT=3306
export MB_DB_USER=
export MB_DB_PASS=
export MB_DB_HOST=localhost".
I would probably recommend that you either find someone who knows how to setup services on Windows or use the Metabase Cloud, so hosting is done for you: https://www.metabase.com/start/hosted/
@ritasc Now, remove the metabase.db.* files (move them somewhere else, trash) and then restart your computer, so you’re sure that all your data is stored in MySQL and you still see "application-database": "mysql" when you look in Diagnostic Info.
I think I’m might be doing something wrong.
I did the above and it worked. And deleted the metabase.db files. But everytime I restart my computer, it restarts the metabase and re-adds the metabase.db.* files .
@ritasc
I would really recommend that you find someone who can run Metabase for you, so you don’t lose your data.
When you start Metabase (java -jar metabase.jar), then it has access to the environment variables set in that session.
I don’t know how you’re starting Metabase, but if you’re using the examples you have provided, then it will use the environment variables to know that should be using MySQL as the application database, and it should not generate the H2 files, when you start Metabase.