How can we migrate data from Confluence 5.6.3 to Confluence 6.10 ?

[Gunjan Yadav]

Questions:

1. How can we migrate data from Confluence 5.6.3 to Confluence 6.10 ?

2. How to migrate database MySQL 5.6.25-enterprise-commercial-advanced  (Confluence 5.6.3) to PostgreSQL 9.6 (Confluence 6.10) ?

[Alexis Robert · Accepted solution]

Hi @Gunjan Yadav, 

this is quite easy to achieve but you'll have to take things one step at a time and test all your upgrades before on a test environment:

1. Check your upgrade path to determine if you can upgrade directly to Confluence 6.10 from 5.6.3
2. Perform the upgrade on your current environment and database
3. Migrate your database to Postgre from MySQL

Let me know if you have any questions, 

--Alexis

[Gunjan Yadav]

Thank you Alexis for your prompt reply. It was quite helpful.

[Shankar Asam {Appfire} · Accepted solution]

Hi Gunjan,

I think your two questions are interrelated to each other. The underlaying core element for migration is, the database. You are migrating off MySQL to PostgreSQL. The best approach here is to take XML backup of your entire confluence 5.6.3(MySQL DB) instance and then restore it on another fresh confluence 5.6.3(with PostgreSQL DB) and once the restoration is complete - try for an upgrade to confluence 6.10.  This way, your data will be migrated along with the database. Please make sure to restore the attachments, logos, images as part of the migration.

If the XML is not feasible due to any reason, then the best option is to export space by space between two instances. You may also plan on migrating users / group incase LDAP / AD isn't used here.

You can also use database migration tools to migrate from MySQL to PostgreSQL and this is entirely vendor specific.

The following document will help,

https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html 

Best,

[Gunjan Yadav]

Hi Shankar,

Thank you so much for your reply.