Export site, users and usermeta from multisite

  • hano

    (@hano)


    14 years, 2 months 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?

The topic ‘Export site, users and usermeta from multisite’ is closed to new replies.