WordPress.org

1. matthijs
   Member
   Posted 3 years ago #

   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?

2. matthijs
   Member
   Posted 3 years ago #

   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.

Topic Closed

This topic has been closed to new replies.