JIRA 6.2.5 import fails

Question

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.

rp3 · Answer

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.

Marcus Silveira · Answer

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?