WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. tomalcala
    Member
    Posted 1 year ago #

    Hi,

    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?

    http://wordpress.org/extend/plugins/wordpress-importer/

  2. Tim Nicholson
    Member
    Posted 11 months 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

About this Topic