Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a database with an unique key constraint.

When I import this database from a dump created by mysqldump I get

'14698-3' for key 'UNQ_CATALOGS EARCH_FULLTEXT_PRODUCT_ID_STORE_ID'

But when I check the database where the export was generated, the constraint violation is not visible:

mysql> select count(*) from catalogsearch_fulltext where product_id = 14698 and store_id = 3;
+----------+
| count(*) |
+----------+
|        1 |
+----------+

I suppose that MySQL does not show the second entry, because it uses the index.

How can I show this entry and fix it easily on the live system?

share|improve this question
    
maybe mysqlshow -kp base table or SHOW INDEX FROM table FROM db; no so sure anyway... –  maniat1k Oct 18 '12 at 15:02
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.