restore backup

[Naeem Alarakhia]

This question is in reference to Atlassian Documentation: Confluence Setup Guide

Hello, I have a .sql back up file that I need to restore in Confluence. I download Confluence Server non production. What are my next steps to restoring the .sql file?

[Nic Brough -Adaptavist- · Accepted solution]

Create a new empty database for Confluence to use.

Install Confluence, pointing it at the empty database.  Make sure the basics all work.

Stop Confluence, drop the database, and restore the .sql into it.

Restart Confluence and re-index it immediately.