upgrade MySQL v3.23 -> v4.04+

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Unipus
Forum Contributor
Posts: 409
Joined: Tue Aug 26, 2003 2:06 pm
Location: Los Angeles, CA

upgrade MySQL v3.23 -> v4.04+

Post by Unipus »

I'm doing a little research on the upgrade process to go from 3.23x to 4.0x, and so far it seems like most people don't have too many problems (at least on Linux servers, which I am). The one area where I do see some people running into trouble is with new user permissions. I see a lot of messages from people who have upgraded and now cannot access their databases, ostensibly due to the way v4 handles permissions as compared to 3.23. Any wise words on how to handle this process smoothly, or any other issues you've run into?
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

I tried it just for fun when reinstalling a system, and at instant got problems during exporting my development db from another server to this one. Why, I cant remember (sorry). But I think that it was a very early version of 4, so many things has happened since.

http://www.mysql.com/doc/en/News-4.0.x.html has a list of the latest changes for each version. The hard part is to read them (all) to track down what bugs exists/are solved.

Regarding the particular user permission subject there are some things you do prior to upgrading more here that might be worth mentioning.

Personally I think v.4+ holds great features, but as most clients/servers still hang on to the older ones (they wont use alpha/beta software) I still feel abit scared to move to it.

I wish you good luck. Just make good backups and try some ;)
Post Reply