Change WordPress user roles and capabilities › Forums › How to or FAQ › Migration of plugin and user roles on from a test to live site. › Reply To: Migration of plugin and user roles on from a test to live site.
If you familiar with SQL and the tools like phpMyAdmin, it’s possible to export/import all user roles with less efforts. Suppose the database prefix is ‘wp_’.
1) Find the WordPress db record with user roles:
SELECT * FROM wp_options WHERE option_name='wp_user_roles';
2) Update all user roles at once:
UPDATE wp_options SET option_value='changed value here' WHERE option_id=NN LIMIT 1;
This post explains in details how and where WordPress stores user roles data.
Do you use any URE Pro additional modules at the test site?