Trouble login after move wp_users table

  • I have an existing website with many users, from which I want to get the users data and import them in a new wp site.

    What I did was create the new blog and then do a

    INSERT INTO 'site2'.'wp_users'
SELECT *
FROM 'site1'.'wp_users' ;

INSERT INTO 'site2'.'wp_usermeta'
SELECT *
FROM 'site1'.'wp_usermeta';

    in phpmyadmin. That works fine.

    However, when I try to login, I can get past the login form but I get to see an empty page with the message:
    you do not have sufficient permissions to access this page.

    So I suspect there’s some secret key I have to change some where else or something to have the second site work with the imported users data. Any ideas?

Viewing 1 replies (of 1 total)
  • Thread Starter matthijs

    (@matthijs)

    I discovered that the problem is within the wp_usermeta table. After migrating the users data from site1 to site2, if you look in the table wp_usermeta there’s the meta_key site1_capabilities. The site1 is the prefix of the first site’s tables. The table prefix for the second site is wp_

    Changing that value from site1_capabilities to wp_capabilities I do get access.

    However, doing this for all 150 users manually is difficult to do and I wonder if that’s the way to do the migration.

Viewing 1 replies (of 1 total)
  • The topic ‘Trouble login after move wp_users table’ is closed to new replies.