After a disaster (physical server lost in flames), we attempted to restore our Confluence Server instance from an XML backup.
The import fails with a known error com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: MySQLIntegrityConstraintViolationException: Duplicate entry '' for key 'unq_lwr_username'
There are available workaround when the entry is not null or when the original database is available (Ha Ha!).
We are running Confluence 6.13.8
The entities.xml file alone is 1.8GB and the import takes days. So that playing with the database while import is running is feasible.
Any help welcome !
Hi Atlassian Community, Remote work has shifted how teams collaborate, and we’ve heard from many of you that Microsoft Teams has become mission critical to many of your workflows, from how you chat...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events