how to skip duplicate records when importing in phpmyadmin
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?
No comments:
Post a Comment