PMA have this problem when importing data in table containing primary key.Importing data containing same primary key value shows error for duplicate entry in table. After considering answer given by Bill Karwin on stackoverflow link http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update . I suggest to keep a check box for ignoring or replacing the new value which is already there in import file as imposing It permanently can create some mess. Suggestions are most welcome. Thanks.