Moving users within a WP Network?

  • Resolved VFHwebdev

    (@vfhwebdev)


    10 years ago

    “Moving” isn’t quite the right verb, because I understand all the sites within my network use the same user tables. Maybe “re-assign” is a better verb.

    Basically I’ve got about 1000 users on one of the sites in my network. That site is getting retired and I need to associate the users with a new site within the same network instead.

    I’ve tried a couple user export/import plugins. All seem to reset the users passwords, which I’d really like to avoid.

    Anybody know of any plugins that will do this?

    Or can I do it via SQL in the database?

Viewing 1 replies (of 1 total)
  • Thread Starter VFHwebdev

    (@vfhwebdev)

    10 years ago

    I think I figured out how to do this with two mySQL commands.

    INSERT INTO usermeta (user_id, meta_key, meta_value)
    SELECT user_id, ‘newBlogID_capabilities’, meta_value FROM usermeta WHERE meta_key=’oldBlogID_capabilities’

    and

    INSERT INTO usermeta (user_id, meta_key, meta_value)
    SELECT user_id, ‘newBlogID_user_level’, meta_value FROM usermeta WHERE meta_key=’oldBlogID_user_level’

    Seems to have worked. I had to do a little clean up for the few users that were already in my new site.

    This would be a really great feature to roll into WP in the future as part of some enhanced user management tools.

Viewing 1 replies (of 1 total)

The topic ‘Moving users within a WP Network?’ is closed to new replies.