restoring a snapshot from one server to another, both multi site..

Site is: http://cruzoilfield.com/

When import is complete, I loose connectivity to the database with the following message:

Error establishing a 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 cruzoilfield.com. Searched for table wp_blogs in database WP_cruzoilfie139440. 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:

wp_users
wp_usermeta
wp_blogs
wp_signups
wp_site
wp_sitemeta
wp_registration_log
wp_blog_versions

ideas?

  • Ivan

    Hey Jeff,

    You could still use Snapshot if you want to import the whole multi site.

    Let me check a few steps you need to do for this:

    1st You need to install Snapshot on the site you are going to move (I am sure you already have it).
    Then you need to go to Snapshot settings in WP Admin -> Snapshots -> Add New(or edit your current one settings). After that scroll a little bit and under "What files to archive" check " Include selected files:".
    Then you will see 5 checkboxes select all but the one for wp-config.php

    2nd Prepare you destination site.
    Install WordPress and Snapshot. Make a copy of your wp-config.php and .htaccess - just in case, and import you Snapshot.
    At this point you shouldn't get any error on the home page, I mean just on the home page, trying to use some link to a page should redirect you back to the original site. If this is so, you can continue.

    3th After you are done importing the snapshot go open your wp-config.php on the live target site and these lines before the MySQL credentials:

    define('WP_HOME','http://example.com');
    define('WP_SITEURL','http://example.com');

    and change "example.com" with your domain name. You can check this link for more information.

    At this point you should be good to, but I am not sure what plugins you are using, so there still might be a problem with the .htaccess, for this reason it is good to have backups from both sites.

    You might want to check the official WordPress documentation for moving a site.

    Let me know if this works for you.

    Thanks,
    Ivan