SQL Database seem to import correctly but only shows partial blog posts

  • 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.

    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 3 replies - 1 through 3 (of 3 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    The sites 1 and 2 are separate WP installs? I’m asking because on Multisite we call each blog on a network a ‘site’ so the terminology can get messy ??

    Did you ONLY copy over wp_posts? IF so you need to get wp_postmeta

    Also keep in mind the authors may get messed up when you do it this way because they’re not always the same between separate WP installs.

    The REAL way to do this is via the WP import/export tool, which lets you merge users and posts, and will skip over any already imported posts ??

    Thread Starter tbadmin

    (@tbadmin)

    Yes, site1 and site 2 are on 2 different servers.

    I copied over wp_posts and wp_postmeta. Also the authors are the same authors that posted before.

    Unfortunately, the import/export tool can’t be used because using it before, it couldn’t capture the 26,000 posts. It was always incomplete.

    I’m still very baffled as to why some of the posts are posting and others aren’t.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    In the DB, check the posts table and see what the post status actually is?

    All I can think is they’re revisions or something weird.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL Database seem to import correctly but only shows partial blog posts’ is closed to new replies.