The wrong way to upgrade MySQL
Expect a longer post in the near future on upgrade procedures. For now enjoy this quote from a gentoo user illustrating the worst way to upgrade.
linolium: is there a way to wipe every single table and start over from scratch?
linolium: ( the upgrade from mysql 4 to 5 didn’t go as smoothly as planned
me: did you read the upgrade notes?
linolium: no, I just hoped that portage would be kind enough to do those things for me
May 20th, 2006 at 4:11 am
This works on Sybase ASE. It’s a shame MySQL can’t do it (yet).
May 21st, 2006 at 10:48 am
I posted this before, but my comment was deleted.
An upgrade like this works fine with a database such as Sybase ASE - the database gets upgraded when the database server is restarted.
So it’s definitely possible, and the user is right to expect it as a feature that should just work.
Hopefully MySQL will get this functionality in the future.
June 1st, 2006 at 12:46 am
The problem wasn’t with mysql not upgrading the database it was with the user not reading anything before doing a major version upgrade. MySQL 5.0 can read tables from 4.1 just fine. The problem was purely application side.
June 5th, 2006 at 12:19 pm
so going from 4.0.17 to 4.1.x is as simple as copying my databases to the 4.1 data dir and starting 4.1?
i’m holding off on 5.0 due to that blog i read about all it’s problems (memory leaks, procedure probs, performance, etc)