New to the community? Start here

Problem with multi database install

I try to use thoses scripts,

Create database (db_0, etc.., db_f, db_vip, db_global)

Install wpmu with db_global for database

etc..

Copy wp_1_XXXX to db_0

Palce all package files in specidier directories.

But when I try to access my plateform wpmu want to go to “wp-admin/install.php”

What can I do ?

Tue, 13 Nov 2007 16:18:48
  • drmike
    • DEV MAN’s Mascot

    wp_1 doesn’t go to db_0. The system makes a md5 hash of the blog_id number, takes the first digirt from that hash and sends it to that database:

    Example:

    $blog_id -> 1.

    An MD5 hash of ‘1’ would be ‘c4ca4238a0b923820dcc509a6f75849b’

    First digit of the hash is ‘c’

    The tables need to be in the db_c database.

    Hope this helps,

    -drmike

  • drmike
    • DEV MAN’s Mascot

    It randomizes which database to send it to. It spreads out the usage more instead of grouping them as per the first digit for example.

    Else when you get to blogs 100-199, they’re all going to go into the ‘1’ database and you get a large db while the rest would be smaller.

    With the hash:

    2 -> c81e728d9d4c2f636f067f89cc14862c -> db_2

    3 -> eccbc87e4b5ce2fe28308fd9f2a7baf3 -> db_e

    4 -> a87ff679a2f3e71d9181a67b7542122c -> db_a

    etc.

  • Luke
    • The Crimson Coder

    There is a tool for this, included with the install, that copies the existing tables to the new db’s for you as well.

    Check the thread on it, as it had a couple minor typo’s, or you could wait until Andrew updates the package soon, and run it then.