• I switched my blog to a new host and in the process went from using WP 2.0 to WP 2.8. I imported the old DB files somewhat successfully but now my DB has tables for old and new content (example below).
    New DB tables:
    wp_1zdut_posts
    wp_1zdut_comments

    Old DB tables:
    wp_posts
    wp_comments

    I want to import the content from these two tables but the tables don’t contain the same cells (not sure if that’s the right lingo) since my old data is from an old WP version and some of the stuff isn’t used in the new WP (ex. in the wp_links table, the old WP used “link_category” whereas the new one does not). I practiced with the wp_links table, deleting obsolete cells and changing the type (ex. int(11) to bigint(20)) to match the cells of the new table. When I attempted to import that content into the new DB table I got an error.

    Since I have so many posts (100+) I really don’t want to copy and paste everything by hand. Any advice on how to move the content of the wp_posts and wp_comments into the new tables correctly is most appreciated (I’m even willing to hire someone to do this if needed).

    Thanks!

  • The topic ‘Moving old versions of posts to new version of DB’ is closed to new replies.