Updating Confluence to use a MySQL database.

[jim]

Hi,

   We have a license for Confluence (running the latest version 6.9.1), but are still using the trial H2 database.  I am trying to convert it to MySQL.  I installed MySQL 5.7.22 and backed up the Confluence database.  I installed another version of Confluence 6.9.1 and followed the procedure to connect to the MySQL database.  All that appeared to work fine.  The problem is when trying to restore the database from the XML file.  I placed the backed up zip file in the Restore directory of the new version of Confluence.  I then followed the procedure to restore the database.  It makes it 90% of the way and fails (see the attached screenshot).  I have done this 6 times.  One of those times I changed all the boolean values in the XML file to int because I read that MySQL does not use boolean values.  Same error.

   Does anyone have any suggestions?

Thanks,

Jim

[Suren Raj]

Hi James.

Based on the error in the screenshot, this error usually occurs when the column for this table is not set up properly. We need to set the ID column to be an incrementing value.

I would recommend working with your DBA to see how they would like to implement this, but in the meantime, you could try something like the steps provided here: https://stackoverflow.com/a/10013372. The steps would be to enable auto-increment on the ID column, for the AO_187CCC_SIDEBAR_LINK table. Once done, please restart Confluence and then check if the issue continues.

Kind Regard

Suren Raj

[jim]

Thanks Suren, but the ID field is already set to auto-increment.  As you know, it is Atlassian's restore process that generates this table.  See the attached image.