This page last changed on Mar 21, 2007 by dave@atlassian.com.

This document outlines how to migrate your data from your existing database to another database.

You should only use this method when moving from the embedded DB to an external DB, or from one type of external DB to another (e.g. Oracle to Postgres). If you are simply moving your DB from one server to another you can just change the JDBC URL in <confluence.home>/confluence.cfg.xml (if you are using a direct JDBC connection) or in the definition of your datasource (if you are connecting via a datasource).

Step One : Backing up your data

  1. Create a backup of your existing data. This is done from the Administration Console. Instructions on how to create a backup can be found here.

  2. Shut down and backup the Confluence Home Directory.

  3. If you are already using an external database, please make a backup of it using the utilities that were installed with it.

Step Two : Configuring the Confluence Home Directory

  1. Create a new Confluence Home Directory. You can place this directory anywhere you like and give it a name of your choice.

  2. Open WEB-INF/classes/confluence-init.properties file in your Confluence installation and change the confluence.home property to point to this new Confluence Home Directory.

Step Three : Setting up Confluence with the new database.

If your databases are not already configured for Confluence, refer to Database Configuration to setup your database access.

  1. Make sure that the JDBC drivers for your database are available to the application server. If you don't already have the JDBC driver, please download one from here.
  2. Make sure that your database is using a case-sensitive collation. Please see this issue for more details: http://jira.atlassian.com/browse/CONF-7917

  3. If you are running the standalone version of Confluence, copy your JDBC database driver (a .jar file), into the confluence-install/common/lib folder.

  4. Start up Confluence. You will see the Confluence Setup Wizard.

  5. Select 'Custom Install'.

  6. Select your database from the drop down list.

  7. Select 'Direct JDBC' and then enter the details of the new database you want to migrate to.
    Read the documentation on Custom Installation for more detailed explanation.

  8. When prompted, restore the contents of the backup you made in Step One into the new Confluence site

You old Confluence data will now be imported to your new database.

RELATED TOPICS
Configuration Guide
Migrate to an External Database

Document generated by Confluence on May 01, 2007 19:29