Support » Fixing WordPress » Imported database not showing posts

  • I have been trying to import an old WordPress database for some months now but with no success.
    I’ve installed the old version which I think was 3.1, then set the theme to the old Classic, which was what I had at that time. (2009)

    I’ve imported the old database and the prefix is still wp_
    My front page info is still there, however, when I click on any post I get the following error:
    The requested URL /archives/2010/03 was not found on this server.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

    I tried to login to the admin page, but it says it simply doesn’t exist.
    When I look at the links for each article, they show links to the old site. I don’t know how to change them and whether that would work?

    Does anyone have suggestions?

Viewing 5 replies - 1 through 5 (of 5 total)
  • I have found all my posts in WordPress admin. They all have permalinks which do not exist. Did WordPress used to make posts an actually page instead of just referencing the database?
    So, with one post, I edited it, then saved it as a draft, then republished it. However, the link on the front page still points to a folder, not to the post in the database?
    Maybe that will help someone help me work out how to view all posts.

    Looks like no-one has a clue. I’m on my own then eh.

    Christine Rondeau


    Volunteer Forum Moderator

    If you have wrong links in your database, the easiest way to fix this is the find and replace the old link with the new one.

    Lorelle wrote a great article on how to do this –

    The article Christine posted is great, but if it’s a bit above your head, you can try running this script. If you read both posts, you’ll see that the common theme is: backup your database first.

    Well I’ve had some luck already.
    I opened the sql backup file and used notepad to change all the url’s to the new domain.
    That didn’t make anything work, but I was looking at the links on the posts and they all had the same format: www.(domain)/archives

    So I created an empty folder in the root called ‘archives’, and lo and behold, all my posts now show, even though there is nothing in that archive folder!
    I have no clue what I’ve done but it appears to work.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Imported database not showing posts’ is closed to new replies.