having problems restoring/migrating with snapshot

Hi there, I am trying to migrate my live site to a test site using snapshot. I have successfully copied the site on snapshot, moved it to my google drive, then download it to my local server then move it over to the new site's upload file and can import it successfully. I always have problems on the restore. I have tried it multiple times. The first time, I followed directions to the tee but it would come back with the plugins intact but then no posts or images. This last time, it came back as a database error. that has happened a couple of times. here is the error:
Could not find site ecraftandsharetest.com. Searched for table wp_8rrx6r_blogs in database ecrafttest. 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_8rrx6r_users
wp_8rrx6r_usermeta
wp_8rrx6r_blogs
wp_8rrx6r_signups
wp_8rrx6r_site
wp_8rrx6r_sitemeta
wp_8rrx6r_registration_log
wp_8rrx6r_blog_versions

What I have done in the past is dump all the database tables and the files and start again with a fresh install. I don't want to keep doing that. How can I start over successfully without having to do that each time? and...... can you talk me through the restore. What should or shouldn't I be check marking on the restore? This is a multisite and I understand that I am just restoring the main site. I have had success migrating/restoring subsites. thanks in advance

  • Luís

    Hi @leslie_diederich,

    Hope you're doing well today!

    Sad to hear the problems you are having.

    I tried it in my install and got the same issue. The migration feature in MultiSite is still in beta version and needs to be more developed.

    When you do the restore, snapshot have a message referring it:

    You can restore the backup to a different blog within your Multisite environment. Note: The destination blog MUST already exist. This migration logic is considered still in beta.

    However, I've confirmed this bug and I flagged the developer, so he can be aware.

    Cheers, Luís

  • Leslie

    Hi Luis,
    I have made some progress. I went into the database and manually changed the urls in wp_blogs
    I have access to the site now. The frontend looks good but the admin dashboard is not functioning correctly and I am getting this error when accessing the admin/network
    (You do not have permission to access this page.)
    I tried deleting the wp-admin and wp-includes files with fresh ones. didn't help.
    I feel so much closer to getting this test site up...don't want to give up yet on this particular attempt. Any ideas? I was thinking about deleting the multisite stuff in the wp-config and going through the process of creating a multisite again...not sure if that is a good idea or not. Are there any other tables in the database that I should be checking especially associated with a multisite? I did already check the wp-options table and the new url was there.

  • Leslie

    Also getting this error in the error log.

    Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.

    Is this excess of internal redirects caused by the fact that the main site has all these links to products from the subsites that are not currently there yet? I have just copied over the main site and plan to copy over 2-3 subsites for testing. What happens to all those links from other sub stores? Is this the problem?

    My htaccess file looks ok. Could it be https verses http causing the redirects? I have ssl security certificates for both the original site I copied from and this test site but am not forcing the https in the wp-config. I also checked the domains and made sure they were both configured the same (both can do www or not)

  • Leslie

    Ok, I got the network admin back. I found this thread and it worked: https://wordpress.org/support/topic/network-super-admin-missing-in-dashboard

    still having problems with the dashboard. it's a gray background with all links on the left side. I have seen posts about this and tried theme and plugin deactivation and other things but still haven't found the solution. I am probably still having those redirect errors. I probably have more things in the database to fix. Need some direction.

  • Leslie

    checked that wp-admin and wp-includes are ok. They are. Already deleted them and installed a fresh install. Checked admin css. It's ok. Checked the database wp-options table again and made sure default theme was correct and current theme was ok. Them switched to twenty sixteen: checked the database again. All was good. The template and stylesheet are saying twenty sixteen. deactivated plugins again for good measure, didn't fix the dashboard. soooo..what is next. I did read a post about someone with this problem contacting their host and it was fixed. Didn't specify why. I will be doing that too. Any help would be appreciated.

  • Luís

    Hi @leslie_diederich,

    Hope you're doing well today!

    Firstly, sorry for my late reply and all the problems it may have caused.

    From what I understood from your replies, you are very close and your issue is only with some misconfiguration in the Admin Dashboard.

    Can be something like this:

    http://manovotny.com/fix-wordpress-admin-styles-not-loading/

    Please, let me know if I understood well, I would like to help solve your problem.

    Cheers, Luís

  • Luís

    Hi @leslie_diederich,

    Hope you're doing well today!

    The test site you are creating is a local website or is online?

    If it's online can you send us the FTP details, so we can check your issue?

    Please send it privately through our contact form:

    https://premium.wpmudev.org/contact/

    Select "I have a different question" for your topic - this and the subject line ensure that it gets assigned to me.

    Send in:

    Subject: "Attn: Luis Lopes"
    - WordPress admin username
    - WordPress admin password
    - Login url
    - FTP credentials (host/username/password)
    - Link back to this thread for reference
    - Any other relevant urls

    Cheers, Luís

  • Leslie

    Luis, the dashboard is back after you did the following:
    I was able to load the Dashboard CSS adding this to your wp-config.php:

    define( 'CONCATENATE_SCRIPTS', false );

    But you are still getting lot's of 500 error, you will need to check the database or remove the plugins and install then again.

    I have done more work on the database by running some more sql queries to change the old url's to the new url. Used this query when I noticed that the mp_products post_permalinks all had the old url. UPDATE wp_mp_products SET post_permalink = REPLACE (post_permalink, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com') WHERE post_permalink NOT LIKE '%{%';

    I am still getting 500 errors so now I will work on replacing all plugins. I can get on the dashboard and see the front end now so at least I can start working on it. Thanks again for all your help.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.