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.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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