View Source

If you've gone through Migrating to Another Database and cannot migrate because of a failed xml backup, this page might help.

Disclaimer

MySQL Migration Toolkit is released by the makers of MySQL and as such, problems with the software should be directed to them. Atlassian Support does not offer support for the Migration Toolkit, nor do we provide support for this migration path. These instructions are offered for strictly informational purposes, and your mileage may vary.

Please backup your database and your home folder before attempting this.

Resources needed

Empty MySQL DB with appropriate credentials to allow creation, deletion, and insertion of tables and rows.
A Windows machine that can both communicate to the Confluence server and the destination DB.
MySQL Migration Toolkit
HSQL Database Engine

Preparation for migrating to MySQL from HSQLDB

Shutdown Confluence
Make a copy of the confluence home folder for backup purposes
Install the Migration Toolkit
Unzip the hsqldb package.
Copy the hsqldb.jar from hsqldb/lib into C:\Program Files\MySQL\MySQL Tools for 5.0\java\lib
Start the MySQL Migration Toolkit

Running the Migration Toolkit

You should be presented with the following screen.
Confluence 5.0 > Migrating from HSQLDB to MySQL > Picture 1.png (Picture 1.png)

Choose Direct Migration

Confluence 5.0 > Migrating from HSQLDB to MySQL > Picture 2.png (Picture 2.png)

Source Database

Confluence 5.0 > Migrating from HSQLDB to MySQL > Picture 4.png (Picture 4.png)

Database System:	Generic JDBC
Connection String:	jdbc:hsqldb: file:PATHTODATABASEFOLDER\confluencedb\\
Username:	sa
Password:	No password. Leave this field blank

Destination Database

Please make sure that the computer that is running MySQL Toolkit is able to access the MySQL server and that the user listed has the ability to create, drop, insert, and update tables.

If your MySQL user has a $ character in the password (such as 'pa$sword'), please change the password or create a temporary account with full permissions. If you do not, the toolkit will throw an "Illegal group reference" error and you will not be able to proceed with the migration.

Confluence 5.0 > Migrating from HSQLDB to MySQL > Picture 5.png (Picture 5.png)

Connecting to Servers

Confluence 5.0 > Migrating from HSQLDB to MySQL > Picture 6.png (Picture 6.png)

You should see the toolkit trying to connect. If you have problems, please click on the advanced options and sql will show you debugging information. Click Advanced to see the log. If you see "Java Heap Space: Out of Memory", you can start the MySQL Migration Toolkit with a -Xmx flag to allocate more memory to the JVM.

After this screen you should come to reverse engineering. Click next.

Source Schemata Selection

Confluence 5.0 > Migrating from HSQLDB to MySQL > Picture 7.png (Picture 7.png)

You should see 2 databases, INFORMATION_SCHEMA and PUBLIC. Choose PUBLIC

Object Type Selection

Confluence 5.0 > Migrating from HSQLDB to MySQL > Picture 8.png (Picture 8.png)

Click Next.

Object Type Mapping

Confluence 5.0 > Migrating from HSQLDB to MySQL > Picture 10.png (Picture 10.png)

Click Show Details on both sections. For Migration Method for Type Schema, choose Multilanguage. For Migration Method for Type Table, choose Data Consistancy/Multilanguage

Click Advanced. Check Enabled Detailed Mappings in Next Step

Detailed Object Mapping

Click to rename the destination database to be the one set aside to migrate to.

From this point on, you should be able to click next all the way through to finish the migration.