Peacebringers

Tag: Linux – General

MySQL 5.0 to 5.1 Upgrade

by Tony on Apr.14, 2009, under Site News

Early this morning, I upgraded the server that runs this site from MySQL 5.0.77 to 5.1.33.  The last time I attempted this, it borked and didn’t like what I attempted to do.  This time around, it’s golden.

MySQL’s upgrade instructions basically state the best way to upgrade is to do a complete dump of all databases, uninstall the old MySQL version, install the latest stable 5.1 version, and then import the data back in.  My first attempt borked.  I’m thinking it was due to some oversight, such as not repairing all the tables beforehand, or some such.  This time, I had one issue with a table that contained cache data.  Since I wasn’t keen on keeping cache data, or rather, since cache data is not vital, I removed it… and voila, we’re back up and running.

Now comes the part where I watch the system like a hawk, and see if any of my web app’s have issues working with MySQL 5.1.  So far, no problems.

Leave a Comment :, , , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit our friends!

A few highly recommended friends...

Archives

All entries, chronologically...