The MU forums have moved to WordPress.org

Multiple sandboxes one database (1 post)

  1. msage
    Member
    Posted 13 years ago #

    I hope someone can help. We are using a test environment and would like to use the same database for multiple sandbox type installs. For instance we have test.domain.com, test1.domain.com, test2.domain.com, etc. We do not want to duplicate the database accross multiple instances.

    I am wondering if this is possible. In the wp_blogs table it lists the siteurls that are allowed, but the blog_id is a primary key and therefore must be unique. Is it possible to remove this constraint safely? Or is there a better way?

    I think - and please correct me if I'm going about this the wrong way - I'd essentially like my wp_blogs table to be something like:

    blog_id | site_id | domain
    1 | 1 | test.domain.com
    5 | 1 | test.domain.com
    9 | 1 | test.domain.com
    1 | 2 | test2.domain.com
    5 | 2 | test2.domain.com
    9 | 2 | test2.domain.com
    1 | 3 | test3.domain.com
    5 | 3 | test3.domain.com
    9 | 3 | test3.domain.com

    Thanks in advance for any help!
    ~Michelle
    WPMU 2.9.2

About this Topic

  • Started 13 years ago by msage