Developed on MySQL 5, production server runs 4

  • Hi there,

    I fear I’ve gotten myself in a little bit of trouble, here. I developed a new site in WP 2.7 locally using MySQL v.5.0.41, and just now I’ve realized that my production server actually runs v.4.1.11. It is not an option to upgrade MySQL on the server.

    So what I need to do is downgrade the database to something I can successfully import into a 4.1.11 environment. I don’t know how to go about doing this and it seems to me like it may be messy.. but I really don’t have a choice, redeveloping from scratch would be a real problem, I’ve gotten pretty in-depth.

    I would really appreciate any help you can offer!

    Thanks in advance. =)

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

  • Did you really do any database customization? If you were local is seems you may not have much, if any real content in the db…so, why not just upload your custom source code to the production server and create a clean db.

    Thread Starter gavinsmith

    (@gavinsmith)

    It’s more the admin settings and some plugin settings that I would really rather not have to think my way through the settings again, but it is an option I suppose.

    Thread Starter gavinsmith

    (@gavinsmith)

    I got about half way through trying to restore all of my settings/categories.posts/pages manually, but I’ve run into an issue… I could explain it, but really what it comes down to is I need to try to downgrade the database. There are issues with IDs all over the place now and if I want the remote to match up with the local for testing, it’s going to take far too much time to work out the conversions mentally (specifically in the way categories are assigned numbers throughout the database and I can’t figure out exactly how it works well enough to modify it confidently).

    I hope that made sense. I’m still looking for a way to do some sort of downgrade, if it’s at all possible.

    I just stumbled across this and haven’t read it, but it looks like it MAY help.

    https://ronaldbradford.com/blog/downgrading-a-mysql-schema-from-5-to-4-part-2-2-2006-01-27/

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Developed on MySQL 5, production server runs 4’ is closed to new replies.