I have 2 identical environments . Now, on one I have created many roles and have assigned users to them . How do I migrate this to the other server which has the same set of users already.

Any suggestions to the problem would be great.

  • 3
    is a complete database migration not an option? I suggest exporting/importing the wp_users and wp_usermeta tables. Jun 16, 2014 at 13:44
  • 3
    The roles themselves live in the wp_options table: SELECT * FROM wp_options where option_name = 'wp_user_roles';
    – Rup
    Jun 16, 2014 at 14:23
  • Thanks Eric and Rup , I will try to Migrate just the WP_user_Roles and post the results here today. Hope all goes well :)
    – Praveen
    Jun 17, 2014 at 7:13

1 Answer 1


So I Migrated the contents of meta_Key 'wp_user_roles' from the wp_options table from one server to another after a backup and it worked , the Roles migration was successful.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.