Mysql:Need to upload data to database, get duplicate key error - how can dup keys be ignored
You'll have to decide what you want to happen when a duplicate is found, because you can:


ignore it (insert ignore ...)
do something (insert ... on duplicate key update)


Since mysqldump usually dumps each table in a single insert statement, you can easily just add those keywords in the dump file.

See this SO post for a more in-depth discussion on the pros and cons of the two possiblities.