Re: [ADDON] Google Member Map
Reply #8 –
First you must promise to backup your member tables. Then assuming you have both databases on your server:
UPDATE newforum.elkarte_members
INNER JOIN oldforum.smf_members
ON oldforum.smf_members.email_address = newforum.elkarte_members.email_address
SET
newforum.elkarte_members.pindate = oldforum.smf_members.pindate,
newforum.elkarte_members.longitude = oldforum.smf_members.longitude,
newforum.elkarte_members.latitude = oldforum.smf_members.latitude
newforum = database name of the new forum, like elkarte_forum
oldforum = database name of the old forum, like smf_forum
smf_members = table name to copy from, as in old forum db_prefix_members
elkarte_members = table name to copy to, as in new forum db_prefix_members
I joined on email address since you can't depend on the member ID being the same across the two and email address should be unique.
Thats going to take a few seconds to run since its not optimal but should work.