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.

#6695
Vladimir
Keymaster

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?