The MU forums have moved to WordPress.org

Sharing user tables among two installs? (2 posts)

  1. takuya
    Member
    Posted 14 years ago #

    Has any wpmu user had successufully setup two or more installs sharing the same user database by using the following method?

    define('CUSTOM_USER_TABLE', 'wp_users');
    define('CUSTOM_USER_META_TABLE', 'wp_usermeta');

    I have test sites named wpmu1.localhost and wpmu2.localhost (using xampp). So far I've managed to setup wpmu2.localhost on the same database as wpmu1.localhost and ran the install script after configuring wpmu2's config.php to use different database prefix, etc.

    Installation gone well, database (user blogs) created, but I see this error that some tables are missing.

    wp2_blogs
    wp2_users
    wp2_usermeta
    wp2_site
    wp2_sitemeta
    wp2_sitecategories

    I've found some blog posts, indicating they have successfully setup shared user table environment on wpmu, but they don't provide how-to unfortunately.

    I know this was originally for single version, but I'd like to make it work with wpmu.

  2. takuya
    Member
    Posted 14 years ago #

    Copied the missing tables from wpmu1 solved. Still need testing...

About this Topic