First, I've read all the way through all of these threads:
I have an existing Multisite instance with 10 blogs, set up in the root of, let's say: http://example.com
I copied the WordPress files to the /staging/ directory in my root.
I copied the entire database into a new database, and modified the new /staging/ wp-config.php file to reflect the new database connection details. It works fine when MULTISITE is defined as "false".
I ran some SQL queries to change all references of http://example.com to http://staging.example.com, which is the subdomain that points to the /staging/ directory. As long as
define( 'MULTISITE', true ); is set, when I load staging.example.com I get a plain "Error establishing database connection" message.
If I try to go to http://staging.example.com/wp-admin I get a more WordPress UI driven error page, that says:
Error establishing database connection
If your site does not display, please contact the owner of this network. If you are the owner of this network please check that MySQL is running properly and all tables are error free.
Could not find site staging.example.com. Searched for table 3v2Uwp_blogs in database xxx_xxx. Is that right?
What do I do now? Read the bug report page. Some of the guidelines there may help you figure out what went wrong. If you’re still stuck with this message, then check that your database contains the following tables:
**** All of these tables exist in the database.
Please please please help! Developing on Multisite so far has been a nightmare. :-/