I have a reasonably large MySQL database that is an import of CSV values from a public data repository. It has come to my attention lately that they occasionally update (ie. correct) data, usually from records published within the last few months. And, when I update my data, I only pull the last few months (not the entire database again).
I'm trying to figure out a way to import the recent data on a regular basis where it will OVERWRITE the current data with the new data if it conflicts. I have previously been doing this using the IGNORE command, to avoid conflicts, but that obviously keeps the original values.
I'd also prefer not to simply overwrite the entire database each month as it is a large file. So importing is a pain at over a gig of data.
So, is there a command like IGNORE that I can use that will have the opposite effect? One that will replace all columns that match unique keys (and thus cause a conflict) with the data from the NEWER import. Or a similar strategy?