Support » Installing WordPress » Upgrade after clean install?

  • I have WP 0.71 running in the “wordpress” directory using “b2xxxx” tables, and WP 1.0.1 running in parallel in “wordpress101” using “wp_xxx” tables. Now that my customization is almost done, I would like to import all the old data from the b2 tables to the wp tables. Unfortunately, phpMyAdmin balks with the error “Column count doesn’t match value count at row 1” so I can’t go that route.
    Does upgrade.php provide the solution? I can’t figure out what it does to the tables. I need to only import the data and not change anything to the customization in either installations, nor to prevent WP 0.71 from continuing to work while I finish my customization of the upgrade and test it.

Viewing 2 replies - 1 through 2 (of 2 total)
  • How did you import the data from the b2 tables to the wp tables? I want to try something like that.
    I doubt it’ll work for me (I’m upgrading from 0.72 to 1.01) but I don’t even know where to start.
    Did you find a solution for this?

    When I upgraded I changed the config file to use the b2xxx tables (ie changed the prefix in the config file to b2) and never set up any wp-xxx ones. I ‘ve seen this recommended around the support forum although I don’t think the upgrade instructions specifically tell you to do this (at least they didn’t originally). Everything else in the instructions, eg running the import script also needs to be done.
    Since then I’ve noticed new tables being added and the old b2 ones beng modified to add the new functionality every time I upgrade, all keeping the b2 prefix as specified, as expected and without problems. I had a few kinks initially because I didn’t change the prefix in the config file until part way through the upgrade (thus messing up the database a little) but they are gone after another couple of upgrades.
    I don’t know how you would go about importing the b2 files after you’ve already set up wordpress, it seems to be something that should be done during the upgrade. But if it is done during the upgrade it works fine 😀

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Upgrade after clean install?’ is closed to new replies.