The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

WordPress Importer
Tables to truncate to avoid duplicate posts/data? (2 posts)

  1. tomalcala
    Posted 4 years ago #


    I have a WP site with data to some date, and a more relevant export with the latest posts etc. I need to import this last one.

    From what I see in the export:
    ( ) All content - This will contain all of your posts, pages, comments, custom fields, terms, navigation menus and custom posts.

    So my configuration shouldn't be at risk.

    But I still would like to not have duplicate content, I'm talking about a lot of posts, comments, pages etc, too many to be checking manually and removing duplicates one by one.

    Is there a user-friendly way to cleanup an obsolete WP before importing? Or which tables should I truncate?


  2. Tim Nicholson
    Posted 3 years ago #

    Hmm. No answer in 10 months? I was wondering exactly the same thing. I created my test website by importing from production a long time ago and now I want to re-import production but have all this data out there in test already.

    So let me see if I can figure this out. Posts and comments should be obvious to truncate, but It exports all categories and tags too so I think we need to clear those too.

    • wp_posts
    • wp_postmeta
    • wp_comments
    • wp_commentmeta
    • wp_terms
    • wp_term_taxonomy
    • wp_term_relationships

    The only tables left (besides custom tables for plugins), should be wp_users, wp_usermeta, and wp_options.

    Actually, differences in wp_options might cause some differences in the how the test site works compared to production, but it also stores the test site's URL and other stuff that should be purposely different. So I'm not going to mess with that.

    I'm bummed that the export doesn't include any users. There doesn't seem to be any easy way to get the users imported.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WordPress Importer
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic