Upgrading a 2.0 Database to 2.5

  • Resolved halninethousand

    (@halninethousand)


    17 years, 10 months ago

    It’s a long story, but the short version is that I had 2.0 on my site (hosted by a 3rd party) and now have 2.5 on it. The database has all the tables in it still from the 2.0 version of my blog with the prefix “hb_” on all the table names. In the same database are all the tables for the new 2.5 version with the prefix “wp_”. As I’m sure people know, when I changed “wp_” to “hb_” in the wp_config.php, it didn’t work. When I pulled up WordPress (http://mysite.com/wordpress), as usual, I got a message that what I was looking for was not there.

    Okay, that was my first shot, so then I looked and saw that there were different tables used for 2.5 than 2.0 (such as using terms instead of categories) and that some of the tables had a slightly different structure.

    My old blog is in 2.0 format and I’d like to convert it to tables using the 2.5 format. Is there any way I can do that?

    Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    17 years, 10 months ago

    1. Backup the database first. Just to have a backup in case you mess up somewhere.

    2. Drop the wp_ tables.

    3. Change the prefix in wp-config back to hb_.

    4. Run the upgrade.php file again to upgrade those tables.

    Thread Starter halninethousand

    (@halninethousand)

    17 years, 10 months ago

    Where is the upgrade.php file? I ran one upgrade and got, “Upgrade not needed.”

    Thanks!

    Thread Starter halninethousand

    (@halninethousand)

    17 years, 10 months ago

    Okay, found the url. Tried it and got this:

    WordPress database error: [Got error 127 from storage engine]
    SELECT * FROM hb_categories ORDER BY cat_ID

    So I checked. The posts are there. The comments are gone and categories are gone. I can still restore the DB so if there’s something else I can do, it’d be a big help.

    Thread Starter halninethousand

    (@halninethousand)

    17 years, 10 months ago

    Fixed.

    I didn’t want to restore and retry without getting any info on what went wrong, but I tried the command that caused the error on the backup db and it worked, so I figured (hoped) it was a glitch. I restored and retried and it worked fine.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    17 years, 10 months ago

    Running a REPAIR on your database would have likely fixed the problem as well. You can do repairs in phpMyAdmin.

    Thread Starter halninethousand

    (@halninethousand)

    17 years, 10 months ago

    The web site I’m on uses a different control panel, not CPanel (isn’t that what phpMyAdmin is part of), so I don’t have that as a choice.

    Thanks, though. Except for an issue with uploading pictures, it’s working now. (I posted that on a new thread.)

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    17 years, 10 months ago

    phpMyAdmin is separate from CPanel, and most every host has it somewhere. Usually on “manage database” or some link like that.

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

The topic ‘Upgrading a 2.0 Database to 2.5’ is closed to new replies.