Support » Installing WordPress » importing a database and making it work

  • Resolved boristhemoggy

    (@boristhemoggy)


    Hi
    I have successfully imported a database from an old installation, and I can see the entries if I open the database direct.
    However, WordPress is not recognising the entries, and my guess is that it has a different name from the previous host I was with.
    How can I make WordPress see this database and use it?

Viewing 14 replies - 1 through 14 (of 14 total)
  • I have successfully imported a database from an old installation

    And what version of WordPress was that?

    It might have been 2.1?
    I’m actually not sure

    You need to find out as you can only import this database into the same version of WordPress. The database version number should be in the .sql file somewhere.

    OK
    So, if I have 5 years of blog, the last update being, I don’t know, 2.2, I have lost everything because I can’t import it into version 2.3.1.
    Is that correct?
    What about getting an older version of WordPress?

    I have lost everything because I can’t import it into version 2.3.1.

    No. Once we’ve identified the correct version, you install that version, import the content and start the upgrade process that will lead (eventually) to 3.2.1. If you have a good backup and some knowledge of what you need to do, nothing will ever be lost.

    What about getting an older version of WordPress?

    You’ll find every single public release of WordPress in the Release Archive.

    OK so this is my plan.
    I have 2.3.1 installed, I restore the backup and read the version number of the sql file that is the backup.
    Do you know where I can get that version number from?

    Then I install the appropriate version of WordPress, and update it to the current version, and this will also update the database.

    The database name is different to the current one, do I have to change that somewhere?

    Can anyone answer this? I had the same problem.
    Thank you

    @juliacream: It is considered impolite to interrupt another poster’s thread. Please post a new topic.

    Do you know where I can get that version number from?

    Try looking in the wp-options table in your .sql backup.

    It would seem silly to start a new thread on exactly the same topic, however, I looked in wp-options and there is nothing there about version numbers.
    It does say database updated = yes, but not to what what version.
    I found more pages then, and one says db_version = 15477?

    It would seem silly to start a new thread on exactly the same topic

    We have good reasons for asking this.

    I found more pages then, and one says db_version = 15477?

    That’s the database for WP 3.01 to 3.05. I thought you said you were originally using 2.x?

    I did start with 2. Perhaps it’s upgraded over time?
    I have what I believe may be the answer though.
    If I had a theme installed on the previous site, and no longer have the same theme, would that prevent the page from displaying?
    I am about to uninstall and reinstall a fifth time to try this theory out.

    would that prevent the page from displaying?

    No.

    I was right.
    Sorry, but that’s exactly what was wrong.

    I viewed source when my page was blank, and all the errors related to ccs statements.
    So I checked the database again, and sure enough it had references to the theme in there.

    So I uninstalled yet again, reinstalled it, but this time set the classic theme, then imported my old database and it’s back perfectly.

    Thanks for your time, I’m chuffed to bits.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘importing a database and making it work’ is closed to new replies.