Instance 1:
MySQL 5.6.12 (Commercial Edition), JIRA 6.2.5, Centos 6.2
Exported the database using MySQL Workbench
Instance 2:
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.
Hi Marcus,
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.
Hi Rathna,
I've found these pages that may shed some light to this problem.
http://stackoverflow.com/questions/15014592/mysql-error-1022-when-creating-table
http://stackoverflow.com/questions/8323145/mysql-error-1022-duplicate-key-in-table
Have you tried using JIRA's XML backup restore or just via a direct database restore?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.