One of my 3rd party applications that writes to my production MySQL database
mydb has nulled SOME of the data in one of my fields
myfield in table
I'm trying to import only the NON null records for this field from my backup
ID field can be used as a unique identifier to make the comparison.
Do I have to import the backup in it's entirety to a temp location, and then build a query/command? Or can I write a query that will also look into an external file? Either way I think the query is a bit above my skill level, so any help will be appreciated.
myfield data in my prod table exists (i.e. not null) then we'll leave that alone, as I'm only looking to import/append
myfield data if it's in the backup and not in the prod field.