Upgrade existing WP site to mysql 5.0?

  • I have an existing website that I have now upgraded successfully to 2.8.4.

    The problem is it was started on a mysql 4.0 database.

    I think it is time I upgrade by converting the site to use mysql 5.

    The server is on 1und1.de and I can easily set up another database for mysql 5.

    However, what is the advice on systematically transferring current 2.8.4 database tables now written on mysql 4 over to mysql 5?

    What advice do the experts have on a step-by-step conversion process?

    Fortunately, this is a test site that is not yet visible under a domain name. So, I have leeway to have it producing errors while the process is underway.

    My searches of the forum and docs here did not come up with my exact situation even though I can’t be the only user to face this need to upgrade to mysql 5 and migrate an existing WP installation.

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

  • That is more in the scope of MySQL forums but your hosting provider should have the answer.

    One thing I’ve learned thus far is that you can’t go from MySQL 4 to 5 simply by exporting the data from 4 into a new DB set up in 5.0.

    You have to first migrate it from 4.0 to 4.1 then to 5.0.

    eots

    (@eots)

    Correction – apparently I was able to move from 4 to 5. I don’t know why it didn’t work the first time around.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Upgrade existing WP site to mysql 5.0?’ is closed to new replies.