Transfer new database to old site, keep posts

  • Resolved tshirtfiend

    (@tshirtfiend)


    14 years, 2 months ago

    I’m working on a redesign of a site for a client. They are still using the main site to post weekly blog entries, but not making any other changes. In the meantime, I’m developing the new site with an export of the database that is now a couple months old.

    I need to keep the posts from the old site, but none of the page data, or other option/user data.

    Can I just move over the non-post related tables from the new database onto the database for the old site? Or is that just going to cause a mess of problems?

    I was thinking that I would move over all tables except:
    wp_commentmeta
    wp_comments
    wp_postmeta
    wp_posts
    wp_usermeta
    wp_users

    Thoughts?

Viewing 8 replies - 1 through 8 (of 8 total)
  • MichaelH

    (@michaelh)

    14 years, 2 months ago

    I’d consider using the Tools->Export from the old blog, and Tools->Import->WordPress at the new blog and delete what you don’t want after the import.

    Thread Starter tshirtfiend

    (@tshirtfiend)

    14 years, 2 months ago

    Ok. I’ll try that first.

    Hopefully it’s not too much of a slog through the XML.

    MichaelH

    (@michaelh)

    14 years, 2 months ago

    Well I wasn’t thinking of “slogging through the XML” as thinking you could delete the stuff you didn’t want after the Import.

    Thread Starter tshirtfiend

    (@tshirtfiend)

    14 years, 2 months ago

    Oh. Hmmm. I suppose that I could do that too….

    Any idea off-hand if it will change post/page IDs and blog settings? I need to keep all of that stuff intact.

    MichaelH

    (@michaelh)

    14 years, 2 months ago

    Any idea off-hand if it will change post/page IDs and blog settings? I need to keep all of that stuff intact.

    Settings would be okay but page/post id’s could be different.

    Thread Starter tshirtfiend

    (@tshirtfiend)

    14 years, 2 months ago

    I’ll plan on importing them, asigning authorship to a certain user, and then deleting duplicates by that author.

    Seem sound?

    MichaelH

    (@michaelh)

    14 years, 2 months ago

    Yes.

    Thread Starter tshirtfiend

    (@tshirtfiend)

    14 years, 2 months ago

    Excellent. Thanks for the help & guidance.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Transfer new database to old site, keep posts’ is closed to new replies.