How can I migrate the Confluence data that is on aws to in-house db server?


I installed Confluence(same version as of my AWS one) and I am in 'Restore Data' step. Currently, there is 500gig of data in AWS. Could someone please redirect me to a link where I can find detailed procedure of taking back-up/dump and pulling it into my in-house db server(mysql).

Thank You

1 answer


Out of curiosity: why are you opting for a database migration rather than an XML export/import? That may be a bit easier, and the only real work you will need to do is adjust the JVM and move attachments over to the correct directory. See:

Additionally, if your attachments are stored in your Database I would advise against this-- as it is now deprecated and can have some pretty heavy performance issues.

Let me know if you're interested in doing it this way and I can help point you in the right direction!

Large DataSets.JPG

Atlassian documentation says, XML Backup for 'large dbs' is not recommended. Now, how large/big is considered a 'large db' for this task?

DB size in my case is 516G. Can I go ahead and use XML Import / Export ?

Thanks for your response Andrew.. 



Indeed- that's a good point. With a database that size I'm thinking that your Database is including attachments, correct? Would you fill me in on what version of Confluence you're using? There may be an opportunity to separate your attachments from your Database as-is right now, if possible, and see where that gets you.

However, if you aren't able to do that due to restrictions on system availability, storage, or internal policies and need to do the database migration, check out this documentation:, which details how to restore a system through a database and what considerations and changes you will need to make. Keep in mind, this document was crafted for newer versions in mind without the attachments held inside the database.

Yes Andrew, there is attachments. Version we have here is Confluence 5.9.4. The XML Backup option we are referring could be applied from the Confluence webpage (Logged-In as admin), right? Irrespective of the size, I just tried the 'BACKUP' option available in the 'General Configuration' page of my Confluence Sandbox webpage but the operation wasn't successful!

Below is the error the webpage displayed 5min after I clicked 'BACKUP'.



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

274 views 2 10
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