Can not open confluence h2 database file

Question

Hey guy's

I would like to open the h2 database file of my confluence instance. But there aren't tables in it.

I took the database file from here: "C:\Program Files\Atlassian\Application Data\Confluence\database\h2db.mv.db".

But now when I try to open it with several tools the program always says that no tables exists in this file. Is it the correct file?

Thank your for your help.

Angel Ruiz_m6y0h0 · Answer

Hi again,

I have found that accessing the H2 embedded db pointing to the file directly can cause problems when Confluence is also running. It looks like the best is to access via TCP with a URL like this:

jdbc:h2:tcp://localhost:9092//Users/.../target/confluence/home/database/h2db

Angel Ruiz_m6y0h0 · Answer

Hi Thomas,

I was able to see the tables by removing the .h2.db extension from the connection URL. I hope it helps

Angel Ruiz_m6y0h0 · Answer

Please disregard this comment cause it is not working