RSS Feed/News How can I merge two *separate* MySQL databases into one, but avoid duplication?

[ENXF NET]

I have two MySQL databases setup, with both having the table “xf_user”, and the columns “email” and “username”. They both have other columns, but not all match. I just want to merge those two particular columns, overwriting/skipping duplicates, to make one unified DB.

I’m not quite sure how to proceed. Any assistance would be most appreciated!

Continue reading...