MySQL 5.6.12 (Commercial Edition), JIRA 6.2.5, Centos 6.2
Exported the database using MySQL Workbench
MySQL 5.6.12 (Community Edition), JIRA 6.2.5, Centos 6.2
When trying to import in the instance 2 via the command line getting an error
ERROR 1022 (23000) at line 118: Can't write; duplicate key in table 'ao_563aee_activity_entity'
Thanks in advance.
I've found these pages that may shed some light to this problem.
Have you tried using JIRA's XML backup restore or just via a direct database restore?
We have taken MySql Dump from production and tried to inject that database into an empty database where a new 6.2.5 is installed and it throws a "( ERROR 1022 (23000) at line 118: Can't write; duplicate key in table 'ao_563aee_activity_entity' )". Its so frustrating seeing it fail with knowing why.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot