Importing Users to Multisite

  • So, im trying to import users to my newly created multisite. I currently have one site nested under the main wordpress instance.

    I took an exported backup of my users via phpmyadmin and saved it. When i had to import it to my new wp instance’s users table, i created two new colums so that it would fit in without any issue.

    The upload happened and it went through.

    When i went into my network dashboard, i saw all my imported members there.
    However, when i went to my site’s dashboard, i saw none of them. Only admin was present.

    I did some research and decided to use multisite-user-management to see if that works.
    I think it tried to work but it failed midway giving me a 500 internal server error.

    I went to check my site’s dashboard and saw that a few users got through. I tried to do the same thing again but it did not happen.

    My issue is that all the users are present under the network dashboard but only a few are under the site dashboard.

    What do i got to do?

Viewing 3 replies - 1 through 3 (of 3 total)

  • Someone else on this forum can probably offer a better suggestion, but this is what I would do:
    Take a look at the differences between the users that came through to your site’s dashboard and the ones that did not. There is likely some difference you can only see when you look at the data using phpmyadmin. once you figure out what’s different, find a way to duplicate that setting/information for the other users.
    From what I understand, multisite creates a table in the database for each site. Presumably, there is as setting in the database that grants user privilages to each site.
    Unfortunately, I’m only making educated guesses here. Others on this forum may be able to give you more information and a better solution to this problem.

    Thread Starter Siddharth Pereira

    (@wickedbl0ke)

    I had a look at the differences. Cant seem to figure what is the issue.

    All my tables are identical and there isnt a way for me to truncate all the old data off them. I dont want to recreate rows coz these are for around 100,000 members.

    [No bumping. If it’s that urgent, consider hiring someone.]

    I looked at the database for my Multisite install. I found there is a table named wp_usermeta. Inside this table, there are entries for [prefix]_[$blog_id]_user_level and [prefix]_[$blog_id]_capabilities. There are other entries in this table that are user specific, but these are the two that would control user privileges on the various sites.

    There may be other ways to modify these values, but I’ve not personally had this problem before. If you can’t find a plugin to help you import your users properly, you may need to edit the SQL tables directly. 100,000 users would be difficult to edit manually, but it’s not too difficult if you create the right SQL script. Unfortunately, that’s something that’s beyond my skill level.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Importing Users to Multisite’ is closed to new replies.