Mulit DB-Instuctions – Basic Informations

Hi Andrew,

got a few questions to set up MultiDB WPMU. I’m trying to convert my WMPU with one DB in a MultiDB with 16DB’s. Here are some of my problems :slight_smile:

1.

Our Server IP Address: 72.123.456.789 / Dedicated Hosting IP: 97.123.456.678

Which IP is here needed? The Server or Dedicatet?

In example you write 123.123.123. -is here the 4th number of the IP-Adress not nessesary?

db-config.php

Line 16:

add_dc_ip(‘72.123.456.’, ‘dc1’:wink:;

add_dc_ip(‘72.123.456.789’, ‘dc1’:wink:;

2.

db_config.php

Line 37: add_db_server(‘global’, …

Do I have to enter here the existing WPMU DB or do I have to create a new DB?

3.

Am I right if I copy the following lines into the db-config.php?

Line 39: add_db_server(‘0’, ‘dc1′, 1, 1,’Database Host Name’,’192.168.0.101′, ‘DB-Name1’, ‘DB-User1’, ‘Pass’:wink:;

Line 40: add_db_server(‘1’, ‘dc1′, 1, 1,’Database Host Name’,’192.168.0.101′, ‘DB-Name2’, ‘DB-User2’, ‘Pass’:wink:;

4.

move-blogs.php

In Line 24-26: ($dbhost, $dbuname, $dbpass) Is here the Login of the existing WPMU DB or the new created DB`s required?

5.

move-blogs.php

Line 19: $dbname = “old_db_name”; // Is here the DB-Name of the existing WPMU required?

Line 21: $newdb_prefix = ‘newdbname’; // Which new of the 16 new created DB?

6.

Whats the list-hashes.php for?

I’m looking forward to hear from you soon.

Best regards and thanks :slight_smile:

  • Andrew
    • Champion of Loops

    Hiya,

    1.

    Our Server IP Address: 72.123.456.789 / Dedicated Hosting IP: 97.123.456.678

    Which IP is here needed? The Server or Dedicatet?

    You can just put both:

    add_dc_ip('72.123.456.', 'dc1');

    add_dc_ip('97.123.456.', 'dc1');

    2.

    db_config.php

    Line 37: add_db_server(‘global’, …

    Do I have to enter here the existing WPMU DB or do I have to create a new DB?

    Some people use their existing database as the global db, some create a new one. Since your using the move-blogs.php script you need to create a global database called PREFIX_global. PREFIX = the prefix of your new databases. “wpmu_global”, “wpmu_0”, “wpmu_1”, etc. “wpmu_” would be the prefix.

    3.

    Am I right if I copy the following lines into the db-config.php?

    Line 39: add_db_server(‘0’, ‘dc1′, 1, 1,’Database Host Name’,’192.168.0.101′, ‘DB-Name1’, ‘DB-User1’, ‘Pass’:wink:;

    Line 40: add_db_server(‘1’, ‘dc1′, 1, 1,’Database Host Name’,’192.168.0.101′, ‘DB-Name2’, ‘DB-User2’, ‘Pass’:wink:;

    Take a look at db-config-sample-16.php. That’s an example file for 16 databases.

    4.

    move-blogs.php

    In Line 24-26: ($dbhost, $dbuname, $dbpass) Is here the Login of the existing WPMU DB or the new created DB`s required?

    The script assumes the user/pass is identical for the existing database and the new databases.

    5.

    move-blogs.php

    Line 19: $dbname = “old_db_name”; // Is here the DB-Name of the existing WPMU required?

    Yes.

    Line 21: $newdb_prefix = ‘newdbname’; // Which new of the 16 new created DB?

    That’s just the prefix of the new databases. So if your 16 databases are named “wpmu_0”, “wpmu_1”, etc then the prefix would be “wpmu_”

    6.

    Whats the list-hashes.php for?

    Just ignore that one.

    Thanks,

    Andrew