Good morning, I hope everything at wpmu dev is going well
I have a question concerning the implementation of Multi DB
We currently have a multisite/multinetwork implementation. Everything was running correctly prior to the Multi DB installation. Our configuration consists of a WP app server communicating with a remote db server on a non standard Mysql port. As an example our configuration consists of WP app server A on IP 111.222.333.444 communicating with MySQL db server B on IP 555.666.777.888 on port 2321. With the standard installation we address this by specifying the db server and port in the wp-config.php file. Everything was working correctly before I started to implement Multi DB.
As I went through the documentation for the setup, I specified the remote host and port in the move-blogs.php file on line 24 as follows: $dbhost = ‘555.666.777.888:2321’;
However in the db-config.php file the port for the db server is not specified and there are two places that seem like it should be?? The first is on line 16 where it specifies the add dc ip (add_dc_ip(‘111.222.333.', 'dc1'):wink:, and starting at line 65 where it is specifying add db server entries (add_db_server('0', 'dc1', 1, 1,’555.666.777.888’,’111.222.333.444', 'wpress_0', ‘user act', ‘password');.
When I ran the move-blogs.php file as documented – the page came up as expected. After I clicked on the copy process on line 5 – everything seemed to work correctly and the page showed me that all the db’s existed and that all tables existed in new db’s as listed. I confirmed this by looking through all the new db’s and seeing all the blog tables spread across them. Unfortunately when I try to access the wp installation I get: Error Establishing a Database Connection
When I look in the wpress_global database I can see all the default tables that come with WP, however, I do NOT see any of the tables that it seems should have been created by the db-config.php file starting at line 25 (affiliate data, affiliate referrers etc).
I have updated the wp-config.php file to reflect using the wpress_global database have not gotten the system back up. I have not been able to go in and activate the multi db plugin