I want to merge data from one database to another. So I create dump with
mysqldump and then import it to another database (with same tables structure). I don't have any problems (such as duplicate entries or something else) in this case.
But I do some merges for testing purposes and I'll do final merge later. So, I want to execute merge (data may be changed) a few times. Notice, my rows in my tables never deletes, only can be inserted or updated.
Can I create mysqldump with ON DUPLICATE option? Or may be I can merge dump that inserts new data and update modified data?
Sure, I can insert
ON DUPLICATE in dump manually, but I want to automate merge process.