Import a 2.0.3 database into 2.3

  • Drew Baker

    (@dbaker)


    16 years, 6 months ago

    Hi Guys,
    I have a 2.0.3 WP blog running fine (although it is hacked to the be-jesus), and I want to make a new blog on the same server and domain using the old 2.0.3 posts. I have installed WP 2.3 into a sub-directory and a new database and it works fine.

    What I want to do is import the 2.0.3 posts into my new 2.3 blog.

    I have tried exporting the 2.0.3 database using PHA and then importing into the 2.3 database using PHA but none of my posts show up.

    What is the best way for me to do this? I can’t upgrade my 2.0.3 because it is very unstable due to all the hacks done to it over the year. It has no admin panel export feature also. All work on the 2.0.3 blog has to be done via PHA.

    Thanks for the help,
    D.Baker

Viewing 7 replies - 1 through 7 (of 7 total)
  • Lester Chan

    (@gamerz)

    16 years, 6 months ago

    Why not upgrade and work from there? That is what I did when I upgraded my super hacked copy of WP 1.5.2 to WP 2.2.3. But of course, you need to know which part you hack and then create a plugin to support that hack in WP 2.3

    Thread Starter Drew Baker

    (@dbaker)

    16 years, 6 months ago

    Yeah that is my problem, it is hard to make my 2.0.3 version work (If I update it, I am 99% sure it will break and I can’t have the downtime). I would rather just make a new 2.3 and import the 2.0.3 database. Is that possible?

    Lester Chan

    (@gamerz)

    16 years, 6 months ago

    it is possible but I don’t think anybody will have the right mind to do it as it requires ALOT of work.

    What I did was to clone my website to another installation then upgrade/work my way from there then once it is tested fully and then close my main site for a few hours and perform the upgrade on the latest database dump of my site.

    kardjo

    (@kardjo)

    16 years, 6 months ago

    Hi all,
    I have similar problem. Current installation is 2.0.2.
    I have new WP 2.3 at another site.
    When I’m going to import, it required a file that generated from old wordpress.

    Since 2.0.2 have no ‘export’ button, how to create XML type of my 2.0.2 database? I need it, so my WP 2.3 can import from.

    Please, I need your helps.

    moshu

    (@moshu)

    16 years, 6 months ago

    Unless you upgrade you cannot have that “Export” button. Which means that method will not work for you.
    However, you can always do it in the “classic” way – exporting your DB via phpMyadmin and importing it in an existent installation.
    NOTE! Since you will have to delete/drop the existing table from the 2.3. database before importing the old one – you will end up again doing an upgrade, you can’t avoid it.
    So, no, there is no workaround to avoid an upgrade.

    skeezicks

    (@skeezicks)

    16 years, 6 months ago

    I just went through that hoop. Had blog on version 2.0.2, wanted to get to 2.3.

    Exporting a database from one version of WP and importing it into a later version is asking for pain and great gnashing of teeth. This is because the table structures in WP vary from version to version. Later versions may even have tables not found in earlier versions, and vice versa.

    What I did was update the existing 2.0.2 to 2.2.3. I followed the instructions available elsewhere in this site (i.e. in the Docs section).

    First, I disabled all my plugins.

    Then I used phpMyAdmin to export my entire wordpress database to an SQL file. This would be my database backup.

    Next, I FTPed the entire contents of my WP installation (i.e. WP-ADMIN, WP-CONTENTS, WP-INCLUDES, and all the other files in that folder) to my local computer. That included the SQL file made earlier. This would be my WP file backup.

    Then I deleted all those files and folders from the host except my wp-config.php file.

    Next I unzipped the WP 2.2.3 package and FTPed everything up to the host, thereby replacing all the deleted files with the newer versions.

    When that was done, I opened my browser and browsed to http://<mysite>/<mywordpressfolder>/wp-admin/upgrade.php and followed the instructions.

    I then FTPed my custom-made theme file to the site, re-enabled the plugins and I was back up.

    Next I used phpMyAdmin to once again export the database (don’t know if that was really necessary but WTH why not).

    Those are the general steps I took. Your site is probably different so be sure you follow the instructions in the Codex.

    The water is not as cold as it looks!

    Thread Starter Drew Baker

    (@dbaker)

    16 years, 5 months ago

    Skeezicks, thanks for the help. That sounds like what I will try. Just one question, what did you do with you 2.0.2 WP-CONTENTS folder after you had upgraded to 2.3? Did you just overwrite the 2.3 folder with the 2.0.2 WP-CONTENTS?

    Thanks again!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Import a 2.0.3 database into 2.3’ is closed to new replies.