Migrating blog content from one multisite to the other selectively

So I have a WP multisite install where our client made changes over on a staging site. But now we need to bring the changed tables back in.

I know how to move sub sites with a clear ID (wp_#_) but this is blog ID1.

So i brought in ALL none site specific wp_ tables but nothing. So where is blog id #1 data saved if there is no wp_1_ in my 10k table DB?


  • Tyler Postle
    • CGO

    Hey Matt,

    Hope you're doing well today and thanks for your question!

    The main site will use the wp_posts wp_postsmeta etc. tables. There won't be a wp_1_, at least not normally. Which tables did you make changes too? Making changes to the global tables can be a bit tricky as it can likely affect all sites on the network. Just make sure you have a backup of the database if you don't have already :slight_smile:

    Let me know if you need any further assistance here.

    Talk to you soon!


  • Matt Adams
    • Flash Drive

    Yeah, thats what I thought too.

    So we made a ton of page edits to site 1, including a theme change. I deleted all wp_ tables on the production site, and copied the same wp_ tables from staging to production, but its like nothing happened. No theme change, same pages, etc. Staging has 106 pages, production only shows 84. I have moved the tables over twice, no luck.

    We have a few backups for sure. Its a 3bg db (for unknown reasons)

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.