2 points
Community rank #11624
rumpelstielzchen
NewbieJust Getting Started
MemberLikes (0)
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 :-)
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');
add_dc_ip('72.123.456.789', '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?
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');
Line 40: add_db_server('1', 'dc1', 1, 1,'Database Host Name','192.168.0.101', 'DB-Name2', 'DB-User2', 'Pass');
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?
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');
Line 40: add_db_server('1', 'dc1', 1, 1,'Database Host Name','192.168.0.101', 'DB-Name2', 'DB-User2', 'Pass');
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_"
Responses (1)
Erstwhile founder (joined May 2007) Likes (0)
Hiya,
You can just put both:
add_dc_ip('72.123.456.', 'dc1');add_dc_ip('97.123.456.', 'dc1');
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.
Take a look at db-config-sample-16.php. That's an example file for 16 databases.
The script assumes the user/pass is identical for the existing database and the new databases.
Yes.
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_"
Just ignore that one.
Thanks,
Andrew
Become a member