Making Dev and Prod Instances the Same

We have 3.5 running on a dev server and 3.5 running on a prod server (both are running Windows). The info on the dev server (spaces, not users) is very outdated, so we wanted to make sure both instances had the same info.

I did a backup on the prod server and tried to import it into the dev server and it just stopped after 8% and gave me an error message. Not realizing how bad this was, I didn't copy down the error message, just figured I'd try the import again. Yes, I know that was stupid :-)

Now, I can't even get into Confluence on the dev server because it wiped out our SQL database info.

I am trying to figure out a. how to get the database info restored so I can at least get back in and b. how to make sure both instances have the same info.

I am really new at this and I've read and read and read the documentation until I think I am more confused than when all this started. All the advice I've gotten is to try to restore the backup and that sounds like a wonderful plan, but since I cannot even get into Confluence, I have no idea if or how this can be done.

Is it possible to just copy files from my prod backup into the dev folders, restart Tomcat, and make things work? This has been going on for three weeks now and I am really frustrated.

Thanks in advance!

1 answer

Hi Libby,

I would recommend you to scratch the test dev instance including the database, and follow this documentation to restore/clone the production instance -

Essentially, the recommended method requires you to copy/clone the database, and the Confluence Home Directory and build a test instance out of it.

Note that we do not recommend XML backup/restore method, as it is not as reliable and prone to problems.

All the best,


Thanks Hanis! After I wrote this, I talked to our DB admin and he somehow cloned the database on his end and I was finally able to connect.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,544 views 4 13
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you