Title: Moving users within a WP Network?
Last modified: August 31, 2016

---

# Moving users within a WP Network?

 *  Resolved [VFHwebdev](https://wordpress.org/support/users/vfhwebdev/)
 * (@vfhwebdev)
 * [10 years ago](https://wordpress.org/support/topic/moving-users-within-a-wp-network/)
 * “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](https://wordpress.org/support/users/vfhwebdev/)
 * (@vfhwebdev)
 * [10 years ago](https://wordpress.org/support/topic/moving-users-within-a-wp-network/#post-7362327)
 * 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.

## Tags

 * [moving](https://wordpress.org/support/topic-tag/moving/)
 * [network](https://wordpress.org/support/topic-tag/network/)
 * [users](https://wordpress.org/support/topic-tag/users/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 1 reply
 * 1 participant
 * Last reply from: [VFHwebdev](https://wordpress.org/support/users/vfhwebdev/)
 * Last activity: [10 years ago](https://wordpress.org/support/topic/moving-users-within-a-wp-network/#post-7362327)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics