Export Database and Use ON DUPLICATE KEY UPDATE

I'm trying to figure out how to export a few tables and import them into another database using the SQL Export model. Goal being to update current records and add new ones when needed.

I found a thread from 9 years ago that looks promising, but I do not see the option to "insert new and update existing."

I only see insert and insert ignore.

Did that never get implemented?

There is a "replace" mode, which should basically be the same as what you expect from an "insert on duplicate key" mode.