WordPress: moving tables with changed prefix more activities should be done
I copied WordPress tables to another server and changed the prefix of the tables from wp_ to jwp_.
I got a problem, that none of my users can access WP Admin console.
Solution was found in Admin problems after moving wordpress comment.
you should do the following:
- In my table, wp08_usermeta, I changed all occurrences of wp_capabilities, wp_user_level, and wp_autosave_draft_ids to wp08_capabilities, wp08_user_level and wp08_autosave_draft_ids
- Then in table wp08_options I changed wp_user_roles to wp08_user_roles
That’s it. everything worked.