Cannot see old posts after restore

  • Resolved josephtbradley

    (@josephtbradley)


    17 years, 3 months ago

    OK, so I’ve seen several posts about this, but no one actually talks about doing something to make them show up. Here’s my deal: I had a blog on Yahoo!, and switched to another host. I got the new host set up, set up the db, restored my data, and then installed WordPress. I can see my comments, and they have links (which don’t work) to the posts that they belong to. The default “welcome” post was actually put in the wp_posts table (at the end of all my other posts), and I can see that in phpMyAdmin, along with my other posts. All of the non-specific columns (like post_status) look the same on the old posts as they did on the default post. I even deleted the default post, and then checked my table to make sure that WordPress was indeed pulling from that table, and it deleted it from that table. However, my old posts won’t show up at all! Here’s my site if you’re interested. Any help would be much appreciated!
    https://www.josephtbradley.com/wp/

Viewing 6 replies - 1 through 6 (of 6 total)

  • You said “…restored my data, and then installed WordPress.” If you restored your data (such as described in Restoring_Your_Database_From_Backup) you should not have needed to “install” WordPress.

    Are you sure the $table_prefix in your new wp-config.php is the same as the old copy?

    Thread Starter josephtbradley

    (@josephtbradley)

    I don’t understand how I wouldn’t have had to install WordPress on the new hosts: that link describes restoring only your data, not the actual WordPress files (such as themes, etc).
    My table prefix is the same (wp_). As I mentioned, it’s actually writing to the same exact table that my old posts are in. I added two posts, and they are at the end of my old posts (as in new records in the table – checked this in phpMyAdmin). But they just won’t show up in the blog for some reason!

    What version of WordPress ‘files’ (not database tables) was the ‘old’ site?

    What version of WordPress ‘files’ is the ‘new’ site?

    Thread Starter josephtbradley

    (@josephtbradley)

    You know, I’ve just figured it out! My post_type is empty on all of my old posts. I changed one of them to post, and it showed up. Just changing the rest, and I think that should do it!

    The old version was 2, I think. The new blog is 2.3.

    Thread Starter josephtbradley

    (@josephtbradley)

    Just another update: I had only one page “post”, so I used this query to update all of them. Post ID 231 was my page post, so I ran: UPDATE wp_post SET post_type = ‘post’ WHERE ID <> 231; And that worked. ??

    Then the process, since your old blog was at 2.1 would be:
    1. Backup old database
    2. Restore database to new host
    3. Upload 2.3.2 files
    4. Execute wp-admin/upgrade.php
    5. Restore any customizations.
    6. Install/update 2.3.x compatible theme
    7. Install/update 2.3.x compatible plugins

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Cannot see old posts after restore’ is closed to new replies.