mysql - how to skip duplicate records when importing in phpmyadmin

Question

I have a db on my local machine and I want to import the data to the db on my hosting. Both db's are identical, the same table names, column names, etc.

When I export the table from my local db through phpmyadmin and import it through phpmyadmin on my hosting an error pops up telling me that there are duplicate entries for the primary key and stops the whole operation.

How can I import the data through phpmyadmin, skip the duplicate entries, and display a list of the duplicates at the end of the process?

A solution that I can do is call all the values of the primary key in the db at my hosting and filter the duplicates before import. BUT I am wondering if there is a quick solution for this with phpmyadmin?

Answer 1

In phpMyAdmin , in Settings tab, you can try checking the following values:

• Settings -> SQL Queries -> Ignore multiple statement errors

If you are using CSV format:

• Settings -> Import -> CSV -> Do not abort on INSERT error

If you are using SQL format:

• Settings -> Export -> SQL -> Use ignore inserts