WordPress.org

1. tshirtfiend
   Member
   Posted 2 years 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?

2. MichaelH
   Volunteer
   Posted 2 years 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.

3. tshirtfiend
   Member
   Posted 2 years ago #

   Ok. I'll try that first.

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

4. MichaelH
   Volunteer
   Posted 2 years 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.

5. tshirtfiend
   Member
   Posted 2 years 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.

6. MichaelH
   Volunteer
   Posted 2 years 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.

7. tshirtfiend
   Member
   Posted 2 years ago #

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

   Seem sound?

8. MichaelH
   Volunteer
   Posted 2 years ago #

   Yes.

9. tshirtfiend
   Member
   Posted 2 years ago #

   Excellent. Thanks for the help & guidance.

Topic Closed

This topic has been closed to new replies.