# Getting a 'Duplicate key or integrity constraint violation' During XML Import

#### お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

## 症状

When migrating to MySQL from another database, such as HSQL, importing the site backup often fails with an error like this:

Duplicate key or integrity constraint violation message from server


## 原因

Such errors occur because usually MySQL evaluates unique key constraints and primary key constraints in a case insensitive way. So if you have a space with the key "sp" and another with the key "SP", MySQL will refuse to add the second one.

## ソリューション

This problem is avoidable by setting the collation on the database to be case sensitive.