Title: Error migrating multisite
Last modified: August 22, 2016

---

# Error migrating multisite

 *  [ShMk](https://wordpress.org/support/users/shmk/)
 * (@shmk)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/error-migrating-multisite/)
 * Hello,
    I’m trying to migrate a wordpress multisite website using subdomains.
 * I’ve edited the database with the searchandreplace script to change the domain.
   
   I’ve edited the table_prefix, the domain and database connection on config.php.
 * The sites looks ok on the frontend, but in the backend the users on Network Admin
   > Users are not linked to any Sites and I cannot add new users to websites from
   the Network Admin > Sites screen because the Roles dropdown is empty.
 * Any help?

Viewing 1 replies (of 1 total)

 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [11 years, 3 months ago](https://wordpress.org/support/topic/error-migrating-multisite/#post-5768605)
 * > I’m trying to migrate a wordpress multisite website using subdomains.
 * Migrate how?
 * Are you changing the domain or are you just moving to the new server?
 * > I cannot add new users to websites from the Network Admin > Sites screen because
   > the Roles dropdown is empty.
 * So normally you have the prefix `wp_` and the table `wp_options`. In that table
   you have a option named `wp_user_roles` and everything works. But then you make
   a new site, and you pick a different DB prefix, maybe you heard it was more secure,
   or maybe you wanted both tables in the same DB. Either way, if you changed your
   PREFIX to, say `wp_wdssrr_`, then now you have `wp_wdssrr_options` instead, and
   when you copy over your old options content, no one can log in. It’s because 
   you have to rename that option to `wp_wdssrr_user_roles`

Viewing 1 replies (of 1 total)

The topic ‘Error migrating multisite’ is closed to new replies.

## Tags

 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [Sites](https://wordpress.org/support/topic-tag/sites/)
 * [users](https://wordpress.org/support/topic-tag/users/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 1 reply
 * 2 participants
 * Last reply from: [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/error-migrating-multisite/#post-5768605)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics