Support » Plugin: WP STAGING - Backup Duplicator & Migration » wp_user_roles not copied over to staging database

  • Resolved cim

    (@cim)


    Hey great plugin! I was following your guide on how to manually push the changes; changes were updated successfully but then the admin bar suddenly had only a few items showing and no way to access the backend. I managed to restore the roles by wp-cli.

    Was wp_user_roles intentionally deleted in the staging option table?

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Rene Hermenau

    (@renehermi)

    On the staging site, the correct option name will be wpstg0_user_roles.
    That’s why you can not find it under wp_user_roles.

    When you rename the database tables you’ll need to rename the prefix of all option names, as well.

    Here is a migration article that helps you to rename all tables and option names properly: https://wp-staging.com/3-ways-to-change-the-wordpress-database-prefix-method-simplified/

    There are different ways to do so, so we’ve added a migration SQL script there as well.

    Happy Holidays to You
    René

    Thread Starter cim

    (@cim)

    Awesome, it works perfectly now. Merry Christmas and happy holidays to you as well René!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp_user_roles not copied over to staging database’ is closed to new replies.