I have read all of the topics regarding moving Multisite to a new domain and I did not see the problem I'm having.
I copied my database and files and I updated the database using the interconnectit tool. I then got "Error Connecting to Database." I went into my database through PHPMyAdmin and made sure I had updated the contents of the wp_blogs, wp_site, wp_sitemeta, etc., as well as the relevant numbered blog tables. I also made sure that wp-config and .htaccess files were set up properly for multisite with the proper domain etc.
I did a database repair and got this message:
wp_posts: Table 'foo.wp_posts' doesn't exist
wp_comments: Table 'foo.wp_comments' doesn't exist
wp_links: Table foo.wp_links' doesn't exist
wp_options: Table 'foo.wp_options' doesn't exist
wp_postmeta: Table foo.wp_postmeta' doesn't exist
wp_terms: Table 'foo.wp_terms' doesn't exist
wp_term_taxonomy: Table 'foo.wp_term_taxonomy' doesn't exist
wp_term_relationships: Table 'foo.wp_term_relationships' doesn't exist
wp_commentmeta: Table 'foo.wp_commentmeta' doesn't exist
where "foo" is a placeholder for my actual database name.
What I don't understand is: why does it think I need those tables? It is true that they don't exist - because it's a multisite setup!! So where do I go to tell it not to look for those tables but to look for the associated numbered tables that correspond to each blog in the network?
Thank you in advance for any help you can provide.