Cannot import my MySQL database to new server

Question

In phpmyadmin, when I try to import the database, I get this error: http://i.stack.imgur.com/iDBfE.png

I do not understand why it wont let me import it. Im running RedHat x86_64 es5. Both my old and new server are matching in settings and versions. Both are running MySQL 5.1

What is going on? Can anyone please assist me in solving this mystery? Im not very experienced so please be specific in any answer...

Answer 1

Within your table "city" there is a field called "longitude". You have (intentionally or not) configured this field to be unique. However, when you load your database to the new server there is already a record for longitude "144.967--37.8167". As a consequence, you get this error. You can remove this record, or make "longitude" not unique anymore before importing the database.

Answer 2

This error is due to a mismatch between the table definitions and the table contents.

At some point a unique index for the field longitude was added, but the previous existing data wasn't checked, and there was a duplicate entry for that index, so it can't be unique.

You have a couple of options to get this solved

• Remove the duplicate entry if it's really redundant
• If you actually need that entry modify through phpmyadmin the table in order to drop the UNIQUE attribute on the index over the field longitude

Let me know how it goes! ;)