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).
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.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.