Moving WordPress – Problem

  • boomvang

    (@boomvang)


    18 years, 5 months ago

    Hello-

    I’ve read the support docs, and am still having a problem with a WP move.

    Here’s the sequence of events:

    1) Had an older version of WP on a server. Exported the database files and saved as a .sql file on my hard drive.

    2) Copied old blog to my hard drive.

    3) Re-directed URL to new server.

    4) Used Fantastico to install newest version on new server. URL stays the same.

    5) Uploaded my preferred themes.

    Now, I’d like to upload the old pages, posts and comments to my new blog.

    Is this possible? I’m afraid I messed up by failing to upgrade the old blog before exporting it.

    Thanks for any advice.

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

    (@mendezki)

    18 years, 5 months ago

    Just go for it.

    Your fear is basically illogical, since, had you upgraded WP first, it would be exactly the same situation, right? Old database – new files. I’d say WP will update your database when necessary.

    There might be some image url troubles, as you can read in this thread

    Thread Starter boomvang

    (@boomvang)

    18 years, 5 months ago

    Your fear is basically illogical

    Well, no.

    If I had upgraded the old blog first, the entire blog would then be the newest version.

    And therefore, compatible with the version installed by Fatastico on the new server.

    It’s perfectly logical to assume that upgraded files would work better with the new version.

    That said, it may not be a concern…perhaps WP does upgrade database files automatically.

    Back to original question. Let’s say the old database files are OK. What do I upload to the new server, so that old posts, comments and pages work?

    Thanks.

    mendezki

    (@mendezki)

    18 years, 5 months ago

    Yes, well, at some point in your upgrade process you would have had your new WP files on your server and still have the ‘old’ not upgraded (if even necessary) tables in your database, right?

    Which is exactly where you are now, hence I say your fear is illogical. But let’s not get all nitpicky about that, back to the upgrade:

    Since you seem to have your core WP install in place, and your themes too, it’s just a matter of importing the backed-up .sql file into your database.

    The first time you open a page on your website WP will tell you if the tables need upgrading, and if yes, it will do so.

    Importing your old database can be done using phpMySQL or a similar database tool.

    Thread Starter boomvang

    (@boomvang)

    18 years, 5 months ago

    Right.

    Just tried to upload the database using phpMySQL and it gave an error:

    “wp_comments already exists”

    So, how do I overwrite the existing database?

    Thanks-

    mendezki

    (@mendezki)

    18 years, 5 months ago

    I’m not great wit mySQL, but try dropping (deleting) the existing tables you’re trying to replace first.

    Thread Starter boomvang

    (@boomvang)

    18 years, 5 months ago

    OK, will do. Thanks.

    Will report back.

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

The topic ‘Moving WordPress – Problem’ is closed to new replies.