Can't find any Confluence tables in h2db.mv.db

[Rune Stilling]

I'm trying to restore admin access to an old Confluence 5.5 server installation:

http://product-downloads.atlassian.com/software/confluence/downloads/documentation/Confluence_5-5-0_CompleteGuide_PDF_CONF55-050514-2250-24.pdf

I'm using DB-Visualizer to access the file: <confluenc e-home-directory>/database/h2db.mv.db

Problem is that it seems the db contains only standard H2-database information and there's no cwd_user table. Am I connecting to a wrong db-file or looking the wrong place?

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

I think you're looking at the wrong file - that h2 database does not have a Confluence in it at all.

Have a look at <confluence home>/confluence.cfg.xml - what does the database URL say?

For example, one of mine on this machine says

<property name="hibernate.connection.url">jdbc:hsqldb:/mnt/data/dev/xxxxxxx-confluence/conf-data/database/confluencedb;hsqldb.tx=MVCC</property>

So the database file for that one is /mnt/data/dev/xxxxxxx-confluence/conf-data/database/confluencedb.script