Typically, Confluence data is restored from the Administration Console or from the Confluence Setup Wizard.
If you are experiencing problems restoring from an zipped XML backup file, it is still possible to restore provided you have:
Instructions for this method of restoring differ depending on whether you are using the embedded database or an external database (like Oracle, MS SQL Server, MySQL or Postgres).
Embedded Database
If you are running against the embedded database, the database is located inside the database folder of your Confluence Home Directory. Hence, all you need to do is:
confluence-init.properties file to this directory.
External Database
If you're using an external database, you need to do the following.
confluence.cfg.xml file inside the Confluence Home Directory. The value of this property is specified as hibernate.connection.url.confluence-init.properties file to the home directory.Important Directories and Files
Migrating to a Different Database
