WordPress.org

Ready to get started?Download WordPress

Forums

Export site, users and usermeta from multisite (1 post)

  1. hano
    Member
    Posted 2 years ago #

    Hi,
    I need to export all users from a multisite-installation. What I want is a list containing:
    wp_user.user_login | wp_usermeta.wp_capabilities(?) | wp_blogs.path

    that is, a list something like this:

    user1 | editor | site1
    user2 | administrator | site1
    user3 | editor | site2
    user1 | editor | site1
    ..and so on

    I tried but apparently, my knowledge of sql is limited. Any ideas about the right syntax?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags