SQL Database imported corectly but only shows partial blog posts

  • Resolved tbadmin

    (@tbadmin)


    10 years, 10 months ago

    Using PHPmyAdmin, I exported the wp_posts table from site1. I imported it, again using PHPmyAdmin the table into the SQL database for site 2.

    Addl details: In site 2, I dropped the wp_posts table before importing the new table in.

    So on the site in WP, it shows 26,017 posts, but it’s missing about 600 posts. When I went in to check the wp_posts table, to see if the posts are there, the missing posts are in the SQL database table that I’m using.

    I’ve attempted to repair the db and optimize but none worked.

    How do I get the remaining 600 missing posts to show up on the WP site?

Viewing 4 replies - 1 through 4 (of 4 total)

  • I’d recommend that you stop trying to carry out single table imports and instead import a complete database backup.

    Thread Starter tbadmin

    (@tbadmin)

    I attempted to do that in the beginning but because site1 is a WP single site install and site2 is a WP multisite install, when I imported the complete db, it created a redirect loop in site2. So I now have to resort to just importing the tables or I’d have to redesign site2 from scratch.

    Background info: Site2 is a redesigned site with new plugins, theme, etc. Site1 is currently the old live site. The goal is to move the posts from site1 (single site) to site2 (multisite) because posts are still updated daily on site1 and we don’t launch for another month.

    You are probably best asking about this in the Multisite forum.

    Thread Starter tbadmin

    (@tbadmin)

    Okay. I’ll close this thread.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL Database imported corectly but only shows partial blog posts’ is closed to new replies.